This article will address how to set the main MySQL password, create a new database user, assign the new user to a specific MySQL database, and update the connection string to successfully connect to your MySQL database. It is important to know the naming convention created for your MySQL database and users to successfully connect to the MySQL database. This article will address the following:

---

• Bluehost's Naming Convention for the Database and User
• Setting the Main MySQL Password
• Create a New User
• Assign New User to Database
• Re-configuring your code

---

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 your script's password.

Setting the main MySQL Password

Bluerock

1. Log in to your Bluehost control panel.
2. Click the Advanced tab from the side navigation menu to the left.
   
3. Click the MySQL Databases, found under the Databases section of the cPanel.
   
4. Scroll down at the bottom and look for the Current Users section.

   Tip: You may also locate the MySQL Users section by clicking "Jump to MySQL Users."
   

5. Look for the MySQL user you would like to update and click the Change Password right next to it.
    
6. Enter the new password in the "Password" text box. The "Password Strength Meter" on the page will identify the strength of the password.
   

   Note: You have the option to generate a password by clicking the Password Generator button.

7. Click the Change Password Button when finished.

Legacy

1. Log in to your Bluehost control panel.
2. Click the cPanel in the sub-menu that stretches across the top of your screen.
   
3. Click the Reset MySQL Password icon, found under the Databases section of the cPanel.
   
4. Notice the username shown. This is the main username for your account.
5. Enter 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 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."

If you forgot the password to your MySQL database user, you must create a new user with a new password and then assign that user to the database. Do not worry; this will not erase or change any of the data in your database.

Create a New User

1. Log in to your Bluehost cPanel account.
2. Click the Advanced tab from the side navigation menu to the left.
   
3. Click the MySQL Databases icon under the Databases category.
   
4. Locate the MySQL Users section of the MySQL Databases tool. To quickly find this section, click Jump to MySQL Users.
   
5. Under Add New User, enter a username.
   

   Note: The username must be 7 letters or shorter.

6. Enter a password in the Password field.
7. Retype the password in the Password (Again) field.
8. Click Create User.

Assign New User to Database

1. Under "Add User to Database," select the newly created user from the User drop-down menu.
   
2. From the Database drop-down menu, select the existing database to which you need the password reset.
3. Click Add.
4. From the MySQL Account Maintenance screen, select the privileges you wish to grant the user or select ALL PRIVILEGES.
   
5. Click Make Changes.
   

You may remove the old user from the database by clicking the red "X" next to the user in the "Current Databases" table.

Re-configuring your code

Now that you have a new user and password for your database, you will need to update your configuration file. Update the file to reflect the new database username and password, and your site should now be working as it was before.

Instead of resetting your password, you may be able to find the existing password in your configuration file. If you are not sure where your configuration file is, check this list of different scripts to find its location: Location of Script Configuration Files.