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

# Managing databases and database users in Plesk

> Learn how to create, manage and delete databases and database users in Plesk.

This article describes how to use Plesk to manage databases and database users. You can add, modify, and delete databases and users, as well as manage user database privileges.

## Creating a database

To create a database, follow these steps:

1. Log in to Plesk.
   <Note>
     If you do not know how to log in to your Plesk account, please see [this article](/websites-hosting/plesk/logging-in-and-out-of-plesk).
   </Note>
2. In the left sidebar, click **Databases**. The **Databases** page appears.
3. Click **Add Database**. The **Add a Database** page appears.
4. In the **Database name** text box, type the database name that you want to use.
5. In the **Related site** list box, select a site to associate with the new database, or accept the default value.
6. To create a user for the database, under **Users**, select the **Create a database user** check box.
   <Note>
     If you do not create a user now, you can add a user to the database later.
   </Note>
7. In the **Database user name** text box, type the username that you want to use.
8. In the **Password** text box, type a password for the database user.
   <Tip>
     Alternatively, you can click **Generate** and Plesk generates a random, strong password for you.
   </Tip>
9. Click **Create Database**. Plesk creates the database.

## Deleting a database

To delete a database, follow these steps:

1. Log in to Plesk.
   <Note>
     If you do not know how to log in to your Plesk account, please see [this article](/websites-hosting/plesk/logging-in-and-out-of-plesk).
   </Note>
2. In the left sidebar, click **Databases**. The **Databases** page appears.
3. Locate the database you want to remove, and then click the trash can icon.
4. To confirm database removal, click **Yes**. Plesk removes the database.

## Adding a user to a database

To add a user to a database, follow these steps:

1. Log in to Plesk.
   <Note>
     If you do not know how to log in to your Plesk account, please see [this article](/websites-hosting/plesk/logging-in-and-out-of-plesk).
   </Note>
2. In the left sidebar, click **Databases**.
3. Click the **User Management** tab.
4. Click **Add Database User**. The **Adding Database User** page appears.
5. In the **Database user name** text box, type the username that you want to use.
6. In the **Password** and **Confirm password** text boxes, type a password for the database user.
   <Tip>
     Alternatively, you can click **Generate** and Plesk generates a random, strong password for you.
   </Tip>
7. In the **Database** list box, select a database to assign the new user to, or accept the default.
8. Click **OK**. Plesk adds the user to the specified database.

## Managing database user privileges

To manage database user privileges, follow these steps:

1. Log in to Plesk.
   <Note>
     If you do not know how to log in to your Plesk account, please see [this article](/websites-hosting/plesk/logging-in-and-out-of-plesk).
   </Note>
2. In the left sidebar, click **Databases**.
3. Click the **User Management** tab.
4. Click the name of the database user you want to manage.
5. To change the database user's password, in the **Password** and **Confirm password** text boxes, type a password for the database user.
   <Tip>
     Alternatively, you can click **Generate** and Plesk generates a random, strong password for you.
   </Tip>
6. To change the database to which the user is assigned, select a database in the **Database** list box.
7. To change the database user's privileges for the selected database, in the **Role** list box select an access level.
8. Click **OK**. Plesk updates the user's privileges for the database.
