This interface allows you to set the MySQL® root password.
Warnings:
- 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
rootaccount password in the/root/.my.cnfconfiguration file. Do not edit this file manually.
Note:
You do not need to remember this password unless you plan to log in to MySQL as the 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.
Notes:
- The system grades 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 Generator - x3 documentation.
Warning:
Do not use asterisks (
*), periods (.), or any other special characters in your MySQLrootpassword. If you do, phpMyAdmin will notfunction. If you use the Password Generator feature, select the Numbers button under advanced. - The system grades 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.
Note:
When the remote MySQL server is also a cPanel & WHM server, you must perform additional steps:
- If you change the remote MySQL
rootpassword on the hosting server, you must update the remote MySQL server's/root/.my.cnfconfiguration file. - If you change the remote MySQL
rootpassword on the remote MySQL server, you must update the MySQL profile on the hosting server, and then reactivate the profile.
