HostMonster Web Hosting Help

Setting a Password for the Main MySQL User


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.

Setting the main MySQL Password

  1. Login to your HostMonster Control Panel
  2. Click the Change MySQL Password icon, found under the Databases section of the cPanel.

  3. Example Image

  4. Notice the username shown. This is the main username for your account.
  5. 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.
    Note: This will only change the password for the main MySQL user.
  6. Enter in the same password again in the second "New Password" text box.
  7. Click the Set MySQL Password button. You should then see a message "Your password has successfully been updated, Click here to continue".
Knowledgebase Article 70,067 views bookmark tags: connect database mysql password phpmyadmin username (updated 1133 days ago)

Was this resource helpful?

Did this resolve your issue?

Please add any other comments or suggestions about this content:

Recommended Help Content

This article will explain how to change or reset the password for a MySQL user. (updated 107 days ago)
Knowledgebase Article 2,381 views tags: change mysql password reset user

This article will explain how to change the password for a database in the event that the original password is lost. (updated 985 days ago)
Knowledgebase Article 33,023 views tags: database mysql password

I cannot connect to my database locally or remotely, do I have the correct server, username and password? (updated 2060 days ago)
Knowledgebase Article 127,770 views tags: cannot connect mysql name

Related Help Content

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 161 days ago)
Knowledgebase Article 173,568 views tags: database mysql phpmyadmin

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 994 days ago)
Knowledgebase Article 159,237 views tags: commands database mysql phpmyadmin

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 51 days ago)
Knowledgebase Article 485,852 views tags: creation database mysql

How can I connect to our MySQL database from Dreamweaver? (updated 1199 days ago)
Knowledgebase Article 102,737 views tags: connecting database dream mysql weaver

A guide to duplicating a MySQL database using phpMyAdmin (updated 994 days ago)
Knowledgebase Article 32,791 views tags: databases mysql phpmyadmin

How to Restore your MySQL Database? (updated 1182 days ago)
Knowledgebase Article 157,861 views tags: admin database mysql php phpmyadmin restore

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password? (updated 2188 days ago)
Knowledgebase Article 87,332 views tags: access mysql password permission

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 992 days ago)
Knowledgebase Article 39,133 views tags: Plesk cpanel databases mysql phpmyadmin