Retrieve or Reset the Root MySQL Password
MySQL AB was a software company that was founded in 1995. It was acquired by Sun Microsystems in 2008; Sun was in turn acquired by Oracle Corporation in 2010.
This is a quick tutorial how to reset your MySQL root password. It does require root access on your server.
service mysql stop
Start MySQL in single-user mode, bypassing password authorization, by pasting in the command below (the ampersand is required):
mysqld_safe --skip-grant-tables &
Now type "mysql" to connect:
At the mysql prompt, change the root password using the following three commands:
UPDATE mysql.user SET password=password("YourNewStrongPassword") WHERE user='root'; FLUSH PRIVILEGES; exit;
Now stop MySQL and start it in normal mode:
service mysql stop service mysql start
Verify that you are able to connect to MySQL by entering "mysql".
Finally, update the MySQL root password in /etc/.my.cnf to match the new value. You can use vi, vim or nano:
Recovering the Root MySQL Password on a cPanel server
The root MySQL credentials are stored locally in a file that only the root user can access. After you’ve connected to the server as root via SSH, you can view the credentials by running the following command:
That should output a result containing the MySQL password, which will appear similar to the following: