How to Reset a MySQL root password

In this tutorial I will show you how to reset a password.

So you’ve managed to misplace your root login for a MySQL database? Do not worry, the following procedure will guide you though resetting the root password on a MySQL database in 7 easy steps.

The MySQL root password is not the same as the system root password. If you have never set a root password for MySQL , most likely it empty as MySQL does not require a password for database connections. However, it is HIGHLY recommended you set a password.

  • Login as root, then stop the MySQL server daemon.
# /etc/init.d/mysql stop
  • Start the MySQL server without a password.
# mysqld_safe --skip-grant-tables &
  • Connect to the MySQL server using the MySQL client.
# mysql -u root
  • Set a new MySQL root user password by entering the following four commands. Be sure to change “NEW_ROOT_PASSWORD” to your desired password.
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW_ROOT_PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
  • Stop the MySQL server.
# /etc/init.d/mysql stop
  • Now start the MySQL server.
# /etc/init.d/mysql start
  • Test to make sure your new MySQL root password works.
mysql -u root -p

 

Tags: , ,

Leave a Reply

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