How to manage databases and database users in Plesk

This article describes how to use Plesk to manage databases and database users. You can add, modify, and delete databases and users, as well as manage user database privileges.

Plesk is no longer included with new A2 Hosting plans, but it is still available on legacy Managed WordPress accounts. You can install Plesk manually on unmanaged VPS and Dedicated servers.

Creating a database

To watch a video that demonstrates the following procedure, please click below:

To create a database, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see 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 now, you can add a user to the database later.
  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.
    Alternatively, you can click Generate and Plesk 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 do not know how to log in to your Plesk account, please see this article.
  2. In the left sidebar, click Databases. The Databases page appears.
  3. In the section for the database that you want to remove, click Remove Database.
  4. To confirm database removal, click Yes. Plesk removes the database.

Adding a user to a database

To add a user to a database, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see 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.
    Alternatively, you can click Generate 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 adds the user to the specified database.

Managing database user privileges

To manage database user privileges, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see 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 database user's password, in the New password and Confirm password text boxes, type a password for the database user.
    Alternatively, you can click Generate and Plesk 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 privileges for the selected database, in the Role list box select an access level.
  8. Click OK. Plesk updates the user's privileges for the database.
Get Managed WordPress Hosting

Article Details

  • Operating System: Linux Hosting
  • Control Panel: Plesk
  • Product: Managed WordPress with Plesk
  • Level: Intermediate

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.