Riccardo Riva

Recover MySQL database root password

Sometimes you couls have to recover MySQL database server password.
You could do it follow these easy steps :

1: Stop the MySQL server process.

/etc/init.d/mysql stop

2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password

mysqld_safe –skip-grant-tables &

3: Connect to mysql server as the root user

mysql -u root

4: Setup new root password

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

5: Exit and restart MySQL server

/etc/init.d/mysql stop

6: Start MySQL server and test it

/etc/init.d/mysql start
mysql -u root -p

Hope this help

Bye
Riccardo

Bookmark It