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

# Managing Your MySQL Databases in Enhance

> Learn how to create and manage MySQL databases and database users in the Enhance control panel.

## Manage database users

Create at least one database user before you create a database so the user can access it.

1. Log in to your Enhance control panel.

2. In the left sidebar, click **Websites**.

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

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

4. Click the **Databases** tab.

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

5. On the **MySQL databases** page, click **Add user**.

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

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

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

7. If one or more databases already exist, they appear in the **Database access** section. Select the checkbox next to each database you want the user to 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.
    * Enter an IP address in the **Remote access IP** field to allow remote database access.
    * Click **Delete** to delete the user.

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

## Manage databases

1. Log in to your Enhance control panel.

2. In the left sidebar, click **Websites**.

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

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

4. Click the **Databases** tab.

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

5. On the **MySQL databases** page, click **Add database**.

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

6. In the **Add database** section, enter the database name.

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

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 **All database privileges** selected.
   * To grant only specific privileges, clear **All database privileges** and select the permissions you want to grant.

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

8. Click **Add**. The new database appears on the **Databases** tab.

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

   * Click **PhpMyAdmin** to open phpMyAdmin.

     <Frame>
       ![](https://files.readme.io/8605e12ac8556bddc9ed26d76577f7411c52fb3595be85a803a648c173e25a8d-image.png)
     </Frame>

   * Add database users to the database or remove them.

   * Click **Upload** to import a SQL file and populate the database.

     <Frame>
       ![](https://files.readme.io/9aaf2194a482341dec70b5e7288ef9ac612f68b0c84991a69c1da87523c0d8f9-image.png)
     </Frame>

   * Click **Download** to export the database as a SQL file.

     <Frame>
       ![](https://files.readme.io/412c7500b5582ba271f09234f3a301582b06050f1bea9e0241054879e4e830fa-image.png)
     </Frame>

   * Click **Delete** to delete the database.

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

## Related articles

* [Managing your WordPress site in Enhance](/enhance/managing-your-wordpress-site-in-enhance)
* [Installing an SSL certificate in Enhance](/enhance/installing-an-ssl-certificate-in-enhance)
* [Managing your Domains in Enhance](/enhance/managing-your-domains-in-enhance)
* [Managing your Email in Enhance](/enhance/managing-your-email-in-enhance)
* [Using the File Manager in Enhance](/enhance/using-the-file-manager-in-enhance)
* [Managing Backups in Enhance](/enhance/managing-backups-in-enhance)
* [Managing FTP accounts in Enhance](/enhance/managing-ftp-accounts-in-enhance)
* [Changing PHP versions and settings in Enhance](/enhance/changing-php-versions-and-settings-in-enhance)
* [Configuring SSH access in Enhance](/enhance/configuring-ssh-access-in-enhance)