Creating Database Users

When you work with a database in Plesk Plesk Panel is the preferred choice for hosting service providers, web designers, and website owners. Plesk Obsidian 18 is the latest release from Plesk and offers a range of new benefits and features for every user type., 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 a number of 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.

To create a database user account

1. Go to Websites & Domains> Databases > database name, and click Add New Database User.
2. Type a user name and a password that will be used for accessing the contents of the database. Click OK.

To change a password for a database user:

1. If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
2. Go to Websites & Domains > Databases > database name > database user name.
3. Type a new password and click OK.

To specify whose user account credentials should be used by default for managing a database through the Webadmin tool:

1. If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
2. Go to Websites & Domains> Databases > database name.
3. Select a checkbox corresponding to the user account you need.
4. Click Default for DB Webadmin.

To remove a database user account:

1. If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
2. Go to Websites & Domains > Databases > database name.
3. Select a checkbox corresponding to the user account that you want to remove.
4. Click Remove, then confirm removing and click OK.