• Sunday, September 21, 2025

Efficiently managing databases and their users is a fundamental aspect of maintaining any web application. The Plesk control panel provides a streamlined interface to perform these critical tasks with ease. This guide will walk you through the essential steps for creating, removing, and configuring database users and their permissions within Plesk, ensuring your data is organized and secure.

Creating a New Database

Follow these steps to establish a new database within your control panel environment.

  1. To begin, log in to the Plesk control panel.
  2. Navigate to the 'Databases' section in the left sidebar. This action will display the Databases page.
  3. Next, click on 'Add Database'. The 'Add a Database' page will then become visible.
  4. Enter your desired database name into the 'Database name' text box.
  5. From the 'Database server' list, choose the appropriate database type you wish to create.
  6. In the 'Related site' list, either select an existing website to link with this new database or accept the default selection.
  7. To ensure secure access, locate the 'Users' section and select the 'Create a database user' checkbox.
  8. Proceed by entering a unique username for the database user in the 'Database user name' text box.
  9. Define a strong password by entering it into both the 'New password' and 'Confirm password' text boxes.
  10. Finally, click 'OK' to finalize the database creation process.

Removing an Existing Database

If a database is no longer needed, you can easily remove it from your system by following these instructions.

  1. Start by logging into the Plesk control panel.
  2. Access the 'Databases' section from the left sidebar. The Databases page will be displayed.
  3. Locate the specific database you wish to remove and click on 'Remove Database' within its corresponding section.
  4. Confirm the removal by clicking 'Yes' when prompted.

Adding a Database User

Creating dedicated users for your databases enhances security and allows for granular access control. Here’s how to add a new database user.

  1. Begin by logging into your Plesk account.
  2. From the left sidebar, click 'Databases'.
  3. Select 'User Management' to open the 'Database Users' page.
  4. Click 'Add Database User'. This will bring up the 'Adding Database User' page.
  5. Choose the appropriate database server type for the new user from the 'Database server' list box.
  6. Enter the desired username for the new database user in the 'Database user name' text box.
  7. Provide a secure password by entering it into both the 'New password' and 'Confirm password' fields.
  8. Assign the new user to a specific database by selecting it from the 'Database' list box, or leave the default selection.
  9. Finally, click 'OK'. The user will now be successfully added to the designated database.

Managing Database User Privileges

Database user privileges dictate what actions a user can perform. It's crucial to manage these permissions effectively to maintain security and functionality.

  1. To manage user privileges, log in to Plesk.
  2. In the left sidebar, click 'Databases'. This will display the Databases page.
  3. Click on 'User Management'.
  4. Select the name of the database user whose privileges you intend to modify.
  5. If you need to change the user's password, enter the new password into both the 'New password' and 'Confirm password' text boxes.
  6. To reassign the user to a different database, select the desired database from the 'Database' list box.
  7. To adjust the user's access level for the chosen database, select the appropriate role from the 'Role' list box.
  8. Conclude by clicking 'OK'. The system will then apply the updated user privileges for the database.
Back