Portal Home > Knowledgebase > cPanel Questions > How do I reset my MySQL root password?

How do I reset my MySQL root 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 stop

Test to make sure your new MySQL root password works.

# mysql -u root -p

Was this answer helpful? YesNo

Add to Favourites    Print this Article

Powered by WHMCompleteSolution