How to add a new user to the Plesk Panel MySQL database?

A user may not have been assigned when the database was created, or you may want to add multiple users to a database and give them different permissions. To add a user to an existing database in the Plesk panel, follow the steps below:

• Log in to the Plesk Panel. If you need support to access the Plesk panel, click here to check our article.
• Once you access the Plesk panel, click the “Databases” button in the menu on the left.
  
• Go to the “User Management” tab.
  
• Click the “+ Add Database User” button.
  
• The window that opens will request some information. You can follow the steps below:
  • Database server: Select MySQL from the dropdown menu.
  • Database user name: Define a username to access the database.
  • Password: Define a password to access the database. If you haven’t created a new password, you can click the “Generate” button to automatically create one.
  • Confirm password: In this field, re-enter the password you specified in the password section.
  • Database: From the dropdown list, select the database to which you want to assign the database user.
  • Finally, click the “OK” button.
    
• If you have successfully completed the steps above, the user you created will be associated with your database. To check and modify the user’s permissions, go back to the “Database > User Management” page and click on the user you created.
  
• On the page that opens, you can select permissions from the “Role” section or click “Show privileges” to grant or revoke the desired permissions.