• Montag, Oktober 20, 2025

Effectively managing databases and their associated users is a crucial aspect of website and application hosting. This guide offers a detailed walkthrough on how to perform these essential tasks within the Plesk control panel. You will learn to create new databases, add and delete users, and configure user privileges to maintain secure and efficient data management.

Creating a New Database

Establishing a new database is the foundational step for any data-driven application. Follow these instructions to create a database within Plesk:

  1. Begin by logging into your Plesk account.
  2. Navigate to the left sidebar and click on Databases. This action will direct you to the Databases management page.
  3. On the Databases page, select Add Database to open the database creation interface.
  4. Enter your desired database name into the Database name text box. Choose a descriptive name that reflects its purpose.
  5. From the Related site drop-down list, select the website you wish to associate with this new database, or simply accept the default assignment.
  6. To ensure secure access, it is recommended to create a dedicated user for your database. Under the Users section, check the box labeled Create a database user.

    Note

    While creating a user during database setup is recommended for immediate access, you always have the flexibility to add a user to the database at a later stage through the User Management section.

  7. Provide a unique username for the database in the Database user name text box.
  8. Enter a strong, secure password in both the New password and Confirm password fields.

    Tip

    For enhanced security, you can utilize the Generate button to have Plesk create a complex, random password automatically.

  9. Finalize the process by clicking OK. Plesk will then proceed to create your new database.

Deleting an Existing Database

When a database is no longer needed, it can be easily removed from your Plesk environment. Exercise caution when performing this action, as it is irreversible and all data within the database will be lost.

  1. Access your Plesk control panel.
  2. Click on Databases in the left sidebar to reach the database management page.
  3. Locate the specific database you wish to delete and click the Remove Database option associated with it.
  4. A confirmation prompt will appear; click Yes to proceed with the permanent removal of the database.

Adding a Database User

Granting access to a database often requires creating a dedicated user with specific credentials. This section outlines how to add a new user and assign them to a specific database.

  1. Log into your Plesk account.
  2. From the left sidebar, select Databases to access the database management interface.
  3. On the Databases page, click User Management. This will display the Database Users overview.
  4. Choose Add Database User to open the form for creating a new database user.
  5. Provide a unique Database user name for the new user.
  6. Enter a strong password in both the New password and Confirm password fields.

    Tip

    Consider using the Generate button for a system-generated, robust password.

  7. In the Database list box, select the database to which this new user will be assigned, or leave the default if appropriate.
  8. Click OK to finalize the creation and assignment of the database user.

Managing Database User Privileges

Controlling database user privileges is essential for maintaining both security and functionality. Plesk allows you to easily modify user access levels and assigned databases to ensure proper control over your data.

  1. Log in to your Plesk control panel.
  2. Access Databases from the left sidebar.
  3. Select User Management to view your list of database users.
  4. Click on the specific database user's name whose privileges you wish to adjust.
  5. To update the user's password, enter a new password in both the New password and Confirm password fields.

    Tip

    As a best practice, use the Generate button for a secure, auto-generated password.

  6. If you need to reassign the user to a different database, select the new database from the Database list box.
  7. To modify the user's access level for the chosen database, select the appropriate role from the Role list box.
  8. Click OK to save the changes and update the user's database privileges.

By following these detailed steps, you can efficiently manage your databases and associated users within Plesk, ensuring optimal performance and security for your web applications.

Zurück