Managing Database User Accounts

Watch the video tutorial

When you work with a database in Plesk, Plesk accesses the database on
behalf of a user account associated with the database. Therefore, every
database should have at least one associated user account; otherwise,
you will be unable to access it.

Any database user can be set as default for a certain database. Plesk
will always access the database using this default user’s credentials
even if there are other users associated with the database. If a
database has several associated user accounts, and none of them are
default, the first account from the list will be used.

Types of Database Users

There are two types of database user accounts in Plesk:

• User accounts which have access to only one particular database.
  If you collaborate with other people on managing a website and wish
  to give them access to the database, you should create separate user
  accounts for them. Each of these accounts is used to access only one
  database. In this case, you first create a database and then user
  accounts.

• Universal user accounts which have access to all databases.

  Universal users have access not only to all existing databases,
  but to all newly created databases as well.

  If you plan to install web apps on your site, it might be convenient
  to create one universal user account, so that all the apps can access
  their databases using this account. In this case, you first create a
  user account and then specify it when installing apps.

  Note: A universal user acts only within one database server. If you use
  several database servers, create a separate universal user account
  for each server.

Operations with Database Users

You can create, update or remove a database user by going to Websites
& Domains > Databases > User Management.

When creating a database user, you will be prompted to provide the user
credentials for accessing the database and the name of the database that
the specified user will access. A universal database user can be
created by selecting Any for a Database.