How to Reset the Root Password – MySQL

Summary: In this post i tried to explain how to Reset the Root Password. Some time when we missed up with mysql root password and server is live its very difficult to reinstall the mysql to reset everything. So its better to reset the root password and get access to the mysql database.

You can reset MySQL database server password with following five easy steps.

Step-1: Stop the MySQL server process.

# /etc/init.d/mysql stop


Stopping MySQL database server: mysqld.

Step-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 &


[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started

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

mysql -u root


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

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.

# /etc/init.d/mysql stop


Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/
mysqld_safe[6186]: ended
[1]+ Done mysqld_safe –skip-grant-tables

Step- 6: Start MySQL server and test it

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


So We have reset root password for MySQL through these simple steps. If there is any issue don’t forget to comments.

Leave a Reply

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