This article applies to 123-reg servers running Plesk.
This article will explain how to assign MySQL privileges to database users in plesk.
Once logged into your Plesk control panel click on the Tools & Settings link under the Server Management section.
Now select Database Servers under Applications & Databases.
Click on your MySQL host name.
Click on the Databases tab.
Now click on the Webadmin icon under the tools section.
You will now enter phpMyAdmin, from the list in the left sidebar, select the appropriate database for which you wish to make user amendments.
Now click on the Privileges tab
If you have already created a user for the particular database following the FAQ on creating database users then click on the Edit Privileges link for the user you wish to amend.
If you have yet to create your user skip to step 10
You can now check on or off the privileges you wish the user to have for this database. When finished click on the Go button to complete.
Adding a new MySQL user with privileges
After following the above steps up to step 8. Click on the Add a new user link.
You can now add a database user name, host, password and set the privileges for the user.
Once finished click on the Go button to complete.