How to reset a mySQL password?

If you have lost your root user password for MySQL, you can reset it with the following procedure:

  • 1. Login to cPanel >> MySQL Databases
  • 2. Delete the Current User with the lost password after writing that username down.
  • 3. Add New User, using the original username, and a new password.
  • 4. Lastly make sure to add the user back to the database it belongs to with appropriate permissions.
  • 928 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL Optimization / Repair Information

How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and...

How can I monitor what my MySQL server is doing?

A handy little Linux application called Mytop fits this just perfectly. This is a near time...

How do I backup a MySQL database?

By logging into cPanel >> Backups you can download and restore any individual MySQL...

Repairing MySQL tables

This should be handled on a case by case basis, but if you are using the default MySQL table type...

Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...