4th Floor, 4 Tabernacle Street London EC2A 4LU

Reset MYSQL root password – Linux

Log on to your Linux machine as the root user. The steps involved in resetting the MySQL root password are to stop the MySQL server, restart it without the permissions active so you can log into MySQL as root without a password, set a new password, and then restart it normally. Here’s how you do it. First, stop the MySQL server:
[bash]# /etc/init.d/mysql stop[/bash]

Now start the MySQL server using the –skip-grant-tables option, which will run the server without loading the permissions settings:
[bash]# mysqld_safe –skip-grant-tables & [/bash]

The & option at the end makes the command you have executed run as a background process. Now log on to your MySQL server as root:
[bash]# mysql -u root[/bash]

It should allow you in without prompting for a password. The following steps will set the new password:

mysql> use mysql;
mysql> update user set password=PASSWORD(”NewMySQLPassword”) where User=’root’;
mysql> flush privileges;
mysql> quit
[/bash] Replace “NewMySQLPassword” with your own password. Here’s what happens here. The first line selects the MySQL configuration tables. The second line updates the value of the field “Password” for the user “root” to “NewMySQLPassword”. The third line flushes the old set of privileges and makes sure your new password is used everywhere. Now, the last step is to restart the server normally and use your new root password to log in:

# /etc/init.d/mysql stop
# /etc/init.d/mysql start
# mysql -u root -pNewMySQLPassword
[/bash] Congratulations, your new MySQL root password is set and your MySQL server is ready to be used again. Remember to update all your applications to use this password if you are using it anywhere.