Knowledgebase
MySQL Root Password Print this Article
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.
Was this answer helpful?
Related Articles
Overview: This interface allows you to permit remote hosts (servers) to access MySQL® databases...
Overview: This interface allows you to change a database user’s password. Because this feature...
Overview: This interface allows you to complete the PostgreSQL® installation process, create...
Overview: This feature allows server administrators to grant ownership of database objects...
Overview This interface allows server administrators to retrieve a list of database users, each...
