Valid for versions 82 through the latest version
Version:
82
Overview
This interface allows you to set the MySQL® root password.
-
Ensure that you set a complex password. If an attacker were to compromise this password, they would have access to any of your server’s databases.
-
By default, cPanel & WHM’s implementation of MySQL stores the MySQL root account password in the
/root/.my.cnfconfiguration file. Do not edit this file manually.
root user.
Create password
To set the MySQL root password, perform the following steps:
-
Enter and confirm the new password in the appropriate text boxes.
Note:- The system evaluates the password that you enter on a scale of 100 points.
0indicates a weak password, while100indicates a very secure password. - Some web hosts require a minimum password strength. A green password Strength meter indicates that the password is equal to or greater than the required password strength.
- Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.
Warning:Do not use asterisks (*), periods (.), or any other special characters in your MySQL root password. If you do, phpMyAdmin will not function. If you use the Password Generator feature, select the Numbers button under advanced. - The system evaluates the password that you enter on a scale of 100 points.
-
Click Change Password.
Remote MySQL
If you use a remote MySQL server, you must choose whether you change the local or the remote server’s root password. By default, the system selects the remote MySQL server.
When the remote MySQL server is also a cPanel & WHM server, you must perform additional steps:
-
If you change the remote MySQL root password on the hosting server, you must update the remote MySQL server’s
/root/.my.cnfconfiguration file. -
If you change the remote MySQL root password on the remote MySQL server, you must update the MySQL profile on the hosting server, and then reactivate the profile.
For more information, read our Troubleshoot MySQL® Profiles documentation.
