Recovering MySQL root Password

You can recover MySQL database server password with following steps:

1. Stop the MySQL server process /etc/init.d/mysqld 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 mysql root account password i.e. reset mysql password

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

5. Exit and restart the MySQL server /etc/init.d/mysqld restart


Leave a Reply

Your email address will not be published. Required fields are marked *