> ## Documentation Index
> Fetch the complete documentation index at: https://kb.hosting.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Managing your MySQL databases in Enhance

> Learn how to manage your MySQL databases and users in the Enhance control panel. This applies to Enhance web hosting and reseller plans

## Managing database users

Before you create a database, you should create at least one database user that will have access to the database. To do this, follow these steps:

1. Log in to your Enhance control panel and go to the customer account you want to manage a MySQL database for.

2. When the control panel appears, in the left sidebar, click **Websites**:

   ![](https://files.readme.io/228bef28a564fa447f4a92d5c208a9c69d68e7e5322737068090c99d2d6b34a5-image.png)

3. On the **Manage websites** page, click the website you want to manage.

4. A list of tabs appears at the top of the page. Click the **Databases** tab:

   ![](https://files.readme.io/afb71b00e7fd7219bf01a587956dcb6b9a0303245609e1042e2e39f867851208-image.png)

5. The **MySQL databases** page appears. Click **Add user**:

   ![](https://files.readme.io/c4463a688a3f9c700bc3ceffc91982ce677a9c6a03b6b006551401e8b6646772-image.png)

6. In the **Add database user** section, type the username and password for the user:

   ![](https://files.readme.io/6644fd2db4a7a68c3283ea6ec692444c49ef10187108b7cd7a755a8627e1f394-image.png)

7. If one or more databases already exist, they appear in the **Database access** section. Select the check box next to any database for which you want to grant the user access.

8. Click **Add**.

9. Click the **Users** tab. The new user appears in the user list.

10. Click the user to modify it. On this page, you can:

    * Click **Reset** to reset the user's password.
    * In the **Remote access IP** text box, type an IP address from which the user can access databases.
    * Click **Delete** to delete the user.

      ![](https://files.readme.io/b60d1bf857ae0ccefece58feed9d520c89f13f3b9f63fec1ae1891c86f027565-image.png)

## Managing databases

You can easily add, modify, and delete databases. To do this, follow these steps:

1. Log in to your account as described in [Managing your website in the Hosting Panel](/docs/managing-your-website-in-the-hosting-panel).

2. When the control panel appears, in the left sidebar, click **Websites**:

   ![](https://files.readme.io/228bef28a564fa447f4a92d5c208a9c69d68e7e5322737068090c99d2d6b34a5-image.png)

3. On the **Manage websites** page, click the website you want to manage.

4. A list of tabs appears at the top of the page. Click the **Databases** tab:

   ![](https://files.readme.io/afb71b00e7fd7219bf01a587956dcb6b9a0303245609e1042e2e39f867851208-image.png)

5. The **MySQL databases** page appears. Click **Add database**:

   ![](https://files.readme.io/4b088057fc656a5ba22b7a5da763d95dd102f05467594384ad242d661aca0325-image.png)

6. In the **Add database** section, in the **Database name** text box, type the name of the database:

   ![](https://files.readme.io/3ede6855b8b9abb3e03c001735ea5c2b85c77b45bf030c91b2a3a91136e75384-image.png)

7. In the **Add database user** section, select one or more users that can access the database.

   * To grant all access privileges to a user, leave the **All database privileges** check box selected. Alternatively, clear the **All database privileges** check box, and then click the specific privileges you want to grant to the user:

     ![](https://files.readme.io/16992882eefc21ae994b22a47e479ac81557967a85385590e91a09c4aac6a3f0-image.png)

8. Click **Add**. On the **Databases** tab appears the new database.

9. Click the database to modify it and access additional features. On this page, you can:

   * Click **PhpMyAdmin** to access phpMyAdmin:

     ![](https://files.readme.io/8605e12ac8556bddc9ed26d76577f7411c52fb3595be85a803a648c173e25a8d-image.png)
   * Add database users to the database or remove database users.
   * Click **Upload** to import a SQL file and populate the database:

     ![](https://files.readme.io/9aaf2194a482341dec70b5e7288ef9ac612f68b0c84991a69c1da87523c0d8f9-image.png)
   * Click **Download** to export a SQL file containing the database:

     ![](https://files.readme.io/412c7500b5582ba271f09234f3a301582b06050f1bea9e0241054879e4e830fa-image.png)
   * Click **Delete** to delete the database:

     ![](https://files.readme.io/910522250ff0e0a315e8a97eb0eea7b6f04fd77e2c581d912f1e3eb15ce86cea-image.png)

<br />