How to reset MySQL root password

As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it.

View Code MYSQL
#Stop the MySQL service.
/etc/init.d/mysql stop
 
#Start the MySQL in the safe mode.
mysqld_safe --skip-grant-tables &
 
#Login into MySQL as root user
mysql -u root
 
#Update the root user password.
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW PASSWORD") where user='root';
mysql> flush privileges;
mysql> quit;
 
Restart the MySQL service & try to login using the new password.
/etc/init.d/mysql stop
/etc/init.d/mysql start

3 Comments to “How to reset MySQL root password”

  1. Paul 11 February 2009 at 5:44 pm #

    it’d be safer to go with

    mysqld_safe –skip-grant-tables –skip-networking &

    Reply
  2. phani kumar.P 11 April 2009 at 8:58 pm #

    here there is no clear answer for this Question, Please Give me clear Answer.

    Reply
  3. phani kumar.P 11 April 2009 at 9:19 pm #

    hey its very Clear thanking you Sir,

    Reply

Leave a Reply to Paul

Click here to cancel reply.