Knowledgebase

Find answer in our article collection



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?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
Is your VPS's managed or Unmanaged ? (Views: 3120)
Can you manage my server ? (Views: 2582)
Do you have a control panel for my server ? (Views: 2361)
What is the minimum requirements for DA ? (Views: 2291)
Can you boot from my own iso file ? (Views: 3673)

QuatroVPS working with this vendors

Socialize

  • Facebook
  • Twitter
  • Linkedin
  • Google+
  • Youtube

Virtual servers for everyone