Gestion des bases de données et des utilisateurs de bases de données dans Plesk

This guide explains how to create, retirer, 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 serveurs cloud.

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, faire un clic Bases de données.
3. Faire un clic 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. Faire un clic 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 Bases de données from the left sidebar.
3. Locate the database you want to remove.
4. Faire un clic 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. Faire un clic Bases de données in the left sidebar.
3. Sélectionner User Management.
4. Faire un clic Add Database User.
5. Enter a username and password.
6. Select the database the user should access.
7. Faire un clic 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 Bases de données 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. Faire un clic 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.