Verwalten von Datenbanken und Datenbankbenutzern in Plesk

This guide explains how to create, entfernen, 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-Server.

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, klicken Datenbanken.
3. Klicken 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. Klicken 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. Offen Datenbanken from the left sidebar.
3. Locate the database you want to remove.
4. Klicken 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. Klicken Datenbanken in the left sidebar.
3. Wählen Benutzerverwaltung.
4. Klicken Add Database User.
5. Enter a username and password.
6. Select the database the user should access.
7. Klicken 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. Gehen zu Datenbanken and open Benutzerverwaltung.
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. Klicken 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.