Managing Database Users and Permissions

Database user management is crucial for controlling access to your databases and ensuring security. Plesk makes it easy to manage database users and their permissions. Follow these steps to configure and manage users for your databases.

Step 1: Log in to Plesk #

1. Open your web browser and go to the Plesk login page.
2. Enter your credentials and click Log in.

Step 2: Navigate to the Databases Section #

1. In the Plesk dashboard, go to the Websites & Domains section.
2. Select the domain where the database is located.
3. Click on Databases to open the database management interface.

Step 3: Access Database User Management #

1. In the Databases section, locate the database you want to manage.
2. Click on the Users link or icon next to the database name to open the user management page.

Step 4: Add a New Database User (Optional) #

1. Click Add New Database User if you need to create a new user.
2. Fill in the required fields:
   • Username: Enter a unique username for the database.
   • Password: Create a strong password or click Generate for a secure password.
3. Assign the user to the desired database.
4. Click OK to save.

Step 5: Modify User Permissions #

1. In the database user management page, select the user whose permissions you want to modify.
2. Adjust the permissions based on your requirements:
   • Read: Allows the user to view data.
   • Write: Allows the user to insert, update, or delete data.
   • Execute: Allows the user to run stored procedures or scripts.
3. Save your changes.

Step 6: Remove a Database User (Optional) #

1. If a user is no longer needed, select the user from the list.
2. Click Remove or Delete to revoke access to the database.
3. Confirm the deletion.

Tips #

• Use unique usernames and strong passwords for database users to enhance security.
• Grant permissions based on the principle of least privilege—give users only the access they need.
• Regularly review and update user permissions to ensure they align with your requirements.