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 64,173 views bookmark tags: connect database mysql password phpmyadmin username (updated 968 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 821 days ago)
Knowledgebase Article 27,098 views tags: database mysql password

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

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 828 days ago)
Knowledgebase Article 128,008 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 829 days ago)
Knowledgebase Article 143,518 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 54 days ago)
Knowledgebase Article 450,248 views tags: creation database mysql

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

How do I import a database using command line? (SSH) (updated 1010 days ago)
Knowledgebase Article 383,878 views tags: command database import line mysql phpmyadmin ssh

A guide to duplicating a MySQL database using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 28,851 views tags: databases mysql phpmyadmin

How to Restore your MySQL Database? (updated 1017 days ago)
Knowledgebase Article 150,116 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 2023 days ago)
Knowledgebase Article 81,559 views tags: access mysql password permission

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