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 67,392 views bookmark tags: connect database mysql password phpmyadmin username (updated 1066 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 39 days ago)
Knowledgebase Article 496 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 918 days ago)
Knowledgebase Article 30,309 views tags: database mysql password

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

Related Help Content

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

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 926 days ago)
Knowledgebase Article 152,637 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 151 days ago)
Knowledgebase Article 471,118 views tags: creation database mysql

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

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

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

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