How to reset the MySQL root password

The following steps describe the procedure to reset the mysql root password on Linux.

1) Stop the mysql server

/etc/init.d/mysql stop

2) Start the mysql server manually without permission tables which allows us to login as root user without password:

mysqld_safe --skip-grant-tables &

3) Login into mysql as root user without a password and switch to the "mysql" database:

mysql -u root mysql

Then execute this SQL query to set a new password for the mysql root user:

use mysql;
update user set Password=PASSWORD('mynewpassword') WHERE User='root';

(Replace "mynewpassword" with the new root password in the above command).

Then logout from the mysql prompt by typing:


4) Now bring back the running mysql instance into the foreground by typing:


and then press [ctrl] + c to kill the mysql process.

5) Start the mysql server again:

/etc/init.d/mysql start

7 thoughts on “How to reset the MySQL root password”

  1. Avatar


    Do we need to update “/usr/local/ispconfig/server/lib/mysql_clientdb.conf” too ?

  2. Avatar

    Yes, if you use ISPConfig 3.

  3. Avatar

    Hello, easier is use debian sys user login located here /etc/mysql/debian.cnf

  4. Avatar

    It did not worked for me.

    I had to use:
    mysqladmin -u root -p’oldpassword’ password ‘newpass’

    And changed the newpass in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

    But I still am getting the same error at the monitor:
    Unable to connect to the database: Access denied for user ‘root’@’localhost’ (using password: YES)

    • Avatar

      It updated now, I removed the error:
      Unable to connect to the database: Access denied for user ‘root’@’localhost’ (using password: YES) from the log

      And it updated successfully!

  5. Avatar

    Thanks brother.
    Its good !

  6. Avatar

    Thanks for getting me ISP config file location 😀 it helped me to locate it without tearing my hear 😀


Leave a Comment