This article explains how to manage databases and database users in Plesk. You can add, edit, and delete databases and users, as well as manage user database privileges.
Creating a database
Follow all these steps to create a database:
1. Log in to Plesk.
If you don’t know about the log in process of your Plesk account, please read this article.
2. In the left sidebar, click Databases. The Databases page appears.
3. Click Add Database. The Add a Database page appears.
4. In the Database name text box, type the database name that you want to use.
5. In the Related site list box, select a site to associate with the new database, or accept the default value.
6. To create a user for the database, under Users, select the Create a database user check box.
If you do not create a user, you can add a user to the database after some time.
7. In the Database user name text box, type the username that you want to use.
8. In the New password and Confirm password text boxes, type a password for the database user.
You can click on the "Generate" option in Plesk alternatively, and it generates a random, strong password for you.
9. Click OK. Plesk creates the database.
Deleting a database
To delete a database, follow these steps:
1. Log in to Plesk.
If you don’t know about the log in process of your Plesk account, please read this article.
2. In the left sidebar, click Databases. The Databases page appears.
3. In the database section in which you want to remove, click Remove Database.
4. To confirm database removal, click Yes. Plesk removes the database.
Adding a user to a database
For adding any user to a database, follow all these steps:
1. Log in to Plesk.
If you don’t know about the log in process of your Plesk account, please read this article.
2. In the left sidebar, click Databases. The Databases page appears.
3. Click User Management. The Database Users page appears.
4. Click Add Database User. The Adding Database User page appears.
5. In the Database user name text box, type the username that you want to use.
6. In the New password and Confirm password text boxes, type a password for the database user.
In the Alternative option, you can click on the Generate option and Plesk generates a random, strong password for you.
7. In the Database list box, select a database to assign the new user to, or accept the default.
8. Click OK. Plesk updates the full information of user privileges for the database.
Managing database user privileges
Follow all of these steps to manage database user privileges:
1. Log in to Plesk.
If you don’t know about the log in process of your Plesk account, please read this article.
2. In the left sidebar, click Databases.
3. Click User Management.
4. Click the name of the database user you want to manage.
5. To change the user's password in the database, and change with New password and Confirm password text boxes, type a password for the database user.
You can click on the "Generate" option in Plesk alternatively, and it generates a random, strong password for you.
6. To change the database to which the user is assigned, select a database in the Database list box.
7. To change the database user's facilitate for the selected database, in the Role list box choose an access level.
8. Click OK. Plesk updates the information of user's privileges for the database.