15
Май
0

Сброс пароля root для mysql в CentOS

Сброс , замена забытого, потерянного пароля root от MySQL server на CENTOS 6
Записки, заметки для сисадмина.

service mysqld stop

mysqld_safe —skip-grant-tables &

точнее 
/usr/bin/mysqld_safe --skip-grant-tables --user=root &

mysql -u root

UPDATE mysql.user SET Password=PASSWORD(‘newpascode’) WHERE User=’root';
FLUSH PRIVILEGES;

quit;

killall -9 -r mysqld

service mysqld restart

Enjoyed reading this post?
Subscribe to the RSS feed and have all new posts delivered straight to you.

Comments are closed.

Celadon theme by the Themes Boutique