How to manage databases and database users in Plesk?

Creating a Database

  • Log in to Plesk.
  • Click Databases in the left sidebar.
  • Click Add Database.
  • Enter the database name in the Database name text box.
  • Select a site to associate with the new database, or accept the default value.
  • To create a user, check the Create a database user box.
  • Enter a username in the Database user name text box.
  • Enter a password in the New password and Confirm password text boxes, or click Generate to use a random password.
  • Click OK.

Deleting a Database

  • Log in to Plesk.
  • Click Databases in the left sidebar.
  • Click Remove Database in the desired database section.
  • Click Yes to confirm.

Adding a User to a Database

  • Log in to Plesk.
  • Click Databases in the left sidebar.
  • Click User Management.
  • Click Add Database User.
  • Enter a username in the Database user name text box.
  • Enter a password in the New password and Confirm password text boxes, or click Generate to use a random password.
  • Select a database in the Database list box.
  • Click OK.

Managing Database User Privileges

  • Log in to Plesk.
  • Click Databases in the left sidebar.
  • Click User Management.
  • Click the name of the database user to manage.
  • To change the password, enter a new password in the New password and Confirm password text boxes, or click Generate.
  • To change the assigned database, select a database in the Database list box.
  • To change the user’s access level, choose a role in the Role list box.
  • Click OK.

Was this article helpful?

Related Articles