How to reset a mySQL password? Print

928

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.

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...

« Back