I'd like to add a new user to a MySql databases with reduced privileges but there is no option in the phpMyAdmin, nor in the cPanel.
Executing SQL commands to achieve this also fails with the following message:
Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
Note: I am using the database user name and password that was setup on the day of creation of the database and is the system admin account.
Any help is highly appreciated.
The option is under MySQL databases in cPanel. There's a create user option way at the bottom, and and add user to database option as well that allows you to set permissions.