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 66,534 views bookmark tags: connect database mysql password phpmyadmin username (updated 1034 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 the password for a database in the event that the original password is lost. (updated 887 days ago)
Knowledgebase Article 29,436 views tags: database mysql password

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

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

Related Help Content

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 894 days ago)
Knowledgebase Article 149,904 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 120 days ago)
Knowledgebase Article 465,428 views tags: creation database mysql

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

A guide to duplicating a MySQL database using phpMyAdmin (updated 895 days ago)
Knowledgebase Article 30,595 views tags: databases mysql phpmyadmin

How to Restore your MySQL Database? (updated 1083 days ago)
Knowledgebase Article 155,512 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 2089 days ago)
Knowledgebase Article 84,194 views tags: access mysql password permission

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

Instructions on changing the name of your database using phpMyAdmin (updated 895 days ago)
Knowledgebase Article 35,565 views tags: cpanel databases mysql phpmyadmin