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 Hébergement Plesk and custom server setups. Database management is commonly used alongside application hosting such as Hébergement cPanel 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. Connectez-vous au panneau de configuration Plesk.
2. In the left sidebar, cliquez Bases de données.
3. Cliquez 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. Cliquez D'ACCORD to complete the process.

[Capture d'écran: 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. Ouvrir Bases de données from the left sidebar.
3. Locate the database you want to remove.
4. Cliquez Remove Database.
5. Confirm the action when prompted.

[Capture d'écran: 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. Cliquez Bases de données in the left sidebar.
3. Sélectionner User Management.
4. Cliquez Add Database User.
5. Enter a username and password.
6. Select the database the user should access.
7. Cliquez D'ACCORD.

[Capture d'écran: 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. Aller à Bases de données et ouvert 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. Cliquez D'ACCORD to apply changes.

[Capture d'écran: Database user privilege settings]

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