Showing results for 
Show  only  | Search instead for 
Did you mean: 

Add new user to MySql databse

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.


Re: Add new user to MySql databse

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.