Managing databases and database users in Plesk

This guide explains how to create, remove, and manage databases and database users in the Plesk control panel. It is written for day to day administration tasks where you need clear control over database access and permissions.

Plesk can be installed and used on VPS and dedicated servers, including environments running Plesk hosting and custom server setups. Database management is commonly used alongside application hosting such as cPanel hosting alternatives or standalone deployments on cloud servers.

Creating a database

Before creating a database, make sure the related domain or subscription already exists in Plesk.

Follow these steps to create a new database:

1. Log in to the Plesk control panel.
2. In the left sidebar, click Databases.
3. Click Add Database.
4. Enter a name for the database.
5. Select the related website, or leave the default selection.
6. To create a database user at the same time, enable the option to create a database user.
7. Enter a username and password for the database user, or generate a strong password automatically.
8. Click OK to complete the process.

[Screenshot: Databases page with Add Database option]

Deleting a database

Removing a database permanently deletes all data stored inside it. Always make sure you have a backup before proceeding.

To delete a database:

1. Log in to Plesk.
2. Open Databases from the left sidebar.
3. Locate the database you want to remove.
4. Click Remove Database.
5. Confirm the action when prompted.

[Screenshot: Database removal confirmation]

Adding a database user

Database users define who can connect to a database and what level of access they have.

To add a new database user:

1. Log in to Plesk.
2. Click Databases in the left sidebar.
3. Select User Management.
4. Click Add Database User.
5. Enter a username and password.
6. Select the database the user should access.
7. Click OK.

[Screenshot: Add Database User screen]

Managing database user privileges

User privileges control what actions a database user can perform, such as reading data, modifying tables, or managing structures.

To edit database user settings and permissions:

1. Log in to Plesk.
2. Go to Databases and open User Management.
3. Click the database user you want to manage.
4. Update the password if required.
5. Select the assigned database.
6. Choose the appropriate role or access level.
7. Click OK to apply changes.

[Screenshot: Database user privilege settings]

Proper privilege management helps reduce security risks and prevents applications from making unintended changes to database data.