cancel
Showing results for 
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.

1 REPLY 1
Employee
Employee

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.