sasha2002 Blog's

Just another blog from admin's

MySQL – reset a lost MySQL root password —

Stop MySQL

The first thing to do is stop MySQL. Assuming you are using Ubuntu Hardy the command is as follows:

sudo /etc/init.d/mysql stop

Safe mode

Next we need to start MySQL in safe mode – that is to say, we will start MySQL but skip the user privileges table. Again, note that you will need to have sudo access for these commands so you don’t need to worry about any user being able to reset the MySQL root password:

sudo mysqld_safe –skip-grant-tables &

Note: The ampersand (&) at the end of the command is required.

All we need to do now is to log into MySQL and set the password.

mysql -u root

Note: No password is required at this stage as when we started MySQL we skipped the user privileges table.

Next, instruct MySQL which database to use:

use mysql;

Reset password

Enter the new password for the root user as follows:

update user set password=PASSWORD(“mynewpassword”) where User=’root’;

and finally, flush the privileges:

flush privileges;


Now the password has been reset, we need to restart MySQL by logging out:


and simply stopping and starting MySQL:

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start


Test the new password by logging in:

mysql -u root -p

You will be prompted for your new password.

Resetting the MySQL root password is very simple using the above procedure and can save many headaches.

Categorised as: Linux

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.