HostMonster Web Hosting Help

Setting a Password for the Main MySQL User

Summary

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 68,493 views bookmark tags: connect database mysql password phpmyadmin username (updated 1092 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 65 days ago)
Knowledgebase Article 1,192 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 944 days ago)
Knowledgebase Article 31,243 views tags: database mysql password

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

Related Help Content

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

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 952 days ago)
Knowledgebase Article 155,149 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 9 days ago)
Knowledgebase Article 475,995 views tags: creation database mysql

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

A guide to duplicating a MySQL database using phpMyAdmin (updated 952 days ago)
Knowledgebase Article 31,844 views tags: databases mysql phpmyadmin

How to Restore your MySQL Database? (updated 1140 days ago)
Knowledgebase Article 156,797 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 2146 days ago)
Knowledgebase Article 85,970 views tags: access mysql password permission

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