Recover MySQL root Password

You can recover MySQL database server password with following five easy steps.
Step # 1: Stop the MySQL server process.

# sudo /etc/init.d/mysql stop

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

# sudo mysqld_safe –skip-grant-tables &

Step # 3: Connect to mysql server as the root user.

# mysql -u root

Step # 4: Setup new mysql root account password i.e. reset mysql password.

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

Step # 5: Exit and restart the MySQL server.

# sudo /etc/init.d/mysql stop

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

Advertisements

2 thoughts on “Recover MySQL root Password

  1. I went through this procedure two days ago. Was running `rake db:create` on the server and forgot to specify the environment. I didn’t notice the problem right away so later, when I couldn’t get into the database, I didn’t realize that I had let rake automatically change the mysql password.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s