Create and Manage MySQL Databases and Users

Databases are the backbone of your website, storing, retrieving, and editing your data. Think of them as a digital file cabinet that holds all the information about your website—the site name, plugins, text, and more. This means the functionality and efficiency of web-based applications heavily rely on databases. As a business owner or website admin, managing your databases effectively is crucial. In this guide, we'll focus on managing your MySQL database in your Account Manager, specifically on steps to create and remove MySQL databases and users in your Account Manager. Let's get started!

• Accessing Your Database Management Panel
• Managing MySQL Databases
• Managing MySQL Database Users
• Summary

To learn how to set up remote access to your database, please refer to our article, How to Connect to a MySQL Database Using Account Manager Remotely.

Accessing Your Database Management Panel

You can manage your databases in the Database Management panel located within your Account Manager.

Already logged into your Account Manager? Use the following link to go to the Database Management panel.

• https://www.bluehost.com/my-account/hosting/details/databases

Not yet logged into your Account Manager? Follow the steps below.

1. Log in to your Bluehost Account Manager.
2. Navigate to the Websites tab on the left side of your Account Manager dashboard and select the website you are working on.

   

   Another way is to navigate to the Hosting tab and click the MANAGE button to select the hosting package you're working on.
   

3. Once you locate your website, click Settings.
   
4. Under the ADVANCED tab, look for the Databases card and click its MANAGE button.
   
5. You can now access your Databases Management panel. Here, you can view and manage your databases and users.
   
   DATABASES tab:
   
   USERS tab:
   
   REMOTE tab:
   

Managing MySQL Databases

Now that you have access to your Database Management panel, let's explore how to manage a MySQL database in your Account Manager.

Here are the actions you can take within the Database Management panel's DATABASES tab:

• Create a MySQL database
• Search for a database
• Check a database
• Add a user
• Access the phpMyAdmin
• Delete a database

How to Create a MySQL Database

1. Under the DATABASES tab of the Database Management panel, click the ADD DATABASE button.
   
2. In the Add Database pop-up, enter your database name and click the ADD DATABASE button.
   

How to Search for a MySQL Database

Under the DATABASES tab of the Database Management panel, you can locate a specific database by using the search box.

How to Check a MySQL Database

1. Under the DATABASES tab, find the database name you want to check for errors.
2. Click the vertical ellipsis icon on the right and select Check Database.
   
3. The system will scan the database for errors. If no issues are found, a green checkmark will appear.
   

How to Add a User

1. Under the DATABASES tab, look for the database to which you want to add a new user.
2. Click the vertical ellipsis icon on the right and select Add User.
   
3. Click the dropdown menu and select + Create a new user.
   
4. Enter a new username and password, then click Select All to grant all privileges to the user.
   

   Note: Please make sure to note down your password securely. It should be at least 12 characters long and include a mix of numbers, special characters (e.g., !, @, #, $, %), and both uppercase and lowercase letters. For security reasons, avoid writing it on paper or storing it in easily accessible places that could lead to accidental sharing or leakage.

5. Once done, scroll down and click the ADD USER button.
   

How to Access the phpMyAdmin

1. Under the DATABASES tab, locate the database from which you want to access the phpMyAdmin.
2. Click the vertical ellipsis icon on the right and select Access phpMyAdmin.

   

The phpMyAdmin page will open in a new tab.

How to Delete a MySQL Database

1. Under the DATABASES tab, locate the database you want to delete 
2. Click the vertical ellipsis icon on the right and select Delete Database.
   
3. An alert pop-up window will appear, informing you that deleting a database will remove all content. Click the DELETE DATABASE button to confirm.

   

Managing MySQL Database Users

On the Database Management panel, you can create and manage the MySQL database users for your website.

Here are the actions you can take within the Database Management panel's USERS tab:

• Create a new database user
• Search for a database user
• Rename a database user
• Change the password of a specific database user
• Add a user to a database
• Delete a database user

How to Create a New Database User

1. Under the Users tab of the Database Management panel, click the CREATE USER button.

   

2. In the Create New User pop-up window, enter a username and password.

   

3. Click the CREATE USER button.

How to Search for a Database User

Under the USERS tab of the Database Management panel, you can locate a database user by using the search box.

How to Rename a Database User

1. Under the Users tab, locate the database user you want to rename.
2. Click the vertical ellipsis icon on the right, then select Rename.

   

3. Enter a new username in the Rename User pop-up window to change the name of the database user.

   

4. Click UPDATE to save the new username.

How to Change the Password of a Database User

1. Under the Users tab, locate the database user for whom you want to change the password.
2. Click the vertical ellipsis icon on the right, then select Change Password.

   

3. Enter the new password in the Change MySQL User Password pop-up to change the password for the selected username.

   

4. Click the CHANGE PASSWORD button.

How to Add a User to a Database

1. Under the Users tab, locate the database user that you want to add to a database.
2. Click the vertical ellipsis icon on the right and select Add to Database.

   

3. In the pop-up, select the database you want to add to the user, then click Select All to grant all privileges to the selected user.

   

4. Once done, scroll down and click the ADD TO DATABASE button.

   

How to Delete a Database User

1. On the Database Management page, go to the Users tab and find the user you want to remove.
2. Click the vertical ellipsis icon on the right and select Delete User.
   
3. An alert pop-up will appear, informing you that deleting a database user will remove all content for that user. Confirm the action by clicking the DELETE USER button.

   

Summary

Managed databases are crucial to maintaining web-based applications such as online stores and websites. This article covered how to access the Database Management page, create and delete databases, check for errors, and manage database users. By following these steps, you can ensure efficient database management and keep your web applications running smoothly and reliably.