Knowledgebase

Setting a Password for the Main MySQL User

I am prompted to set a new MySQL password. What does this mean and how do I change it?
If you have yet to setup a password for your main MySQL username, you will be prompted to do so when logging into cPanel.

Note: If you do not wish to set the password and do not want see this reminder again simply click the link "Don't remind me about this again". You can always change the main MySQL user's password at a later time by clicking the "Reset MySQL Password" icon in cPanel.

What is the main MySQL password used for?

The main MySQL username is primarily used to login to phpMyAdmin however it can also be used in database connection scripts. If you are using the main MySQL username to connect to a database, you will need to change the MySQL user password and update the password in your script.

Note: MySQL users you create will not be affected. This password change is only for the main username as shown on the password change screen.

Note: Before you can use the main MySQL user with any of your databases you must also assign the username to the database. Click Here for further instructions on assigning MySQL users to MySQL databases.

How do I set the main MySQL Password:

  1. Login to your cPane
  2. If you are not automatically prompted to change the MySQL Password, click the icon "Change MySQL Password" found under the Databases section of the cPanel.
  3. Notice the username shown. This is the main username for your account. This password change only changes the MySQL password for this username. This will not change your cPanel password nor other MySQL users you have created.
  4. Enter in a new password in the "New Password" text box. As you type you will see the password requirements which have not yet been met. You can also see your password's strength.
  5. Enter in the same password again in the second "New Password" text box.
  6. Click the "Set MySQL Password" button. You should then see a message "Your password has successfully been updated, Click here to continue".


Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Also Read

Client Login

Email

Password

Remember Me