Loss of MySQL root password?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

1 to stop the MYSQL service

/etc/init.d/mysqld stop

2 using mysqld_safe login security

mysqld_safe --skip-grant-tables &

3 implementation of login, change password etc.

mysql -u -root
use mysql;
update user set password=password('your new password') where user='root';

4 to restart the MySQL service

/etc/init.d/mysqld start
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Beatrice at November 28, 2013 - 9:09 AM