How 2 Guru

As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it.

1. Stop the MySQL service.

/etc/init.d/mysql stop

2. Start the MySQL in the save mode.

mysqld_safe –skip-grant-tables &

3. Login into MySQL as root user

mysql -u root

4. Update the root user password.

mysql> use mysql;
mysql> update user set password=PASSWORD(“NEW PASSWORD”) where user=’root’;
mysql> flush privileges;
mysql> quit;

5. Restart the MySQL service & try to login using the new password.

/etc/init.d/mysql stop
/etc/init.d/mysql start

mysql -u root -p