Granting super priviledges

Raw333

Member
Jan 8, 2019
10
3
3
US
cPanel Access Level
Root Administrator
Good Day - I could use some help in granting super privileges from WHM. Since I'm sole user, I'm ok with granting to all sites. I've looked everywhere within the whm settings but cannot find a solution. Please help, I'm trying to get a new site up and have no privileges for the DB.

This privilege option used to be available when setting up DB's, not anymore?

I have root access and using latest version of cpanel.

No experience from command line, but willing to try if its easy enough. Thanks!
 

rpvw

Well-Known Member
Jul 18, 2013
1,101
465
113
UK
cPanel Access Level
Root Administrator
In cPanel for the account that has the database:

> Click on MySQL® Databases
> Look for the column that is marked Privileged Users
> Click on the user name (be careful not to click on the bin icon at the end of the name which will start the deletion of that user)
> After clicking on the user name, the screen should present you with a new page Manage User Privileges where you can set the privileges for the user.
> Don't forget to click the Make Changes button at the bottom when you have finished !! o_O
 
  • Like
Reactions: cPanelLauren

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,273
313
Houston
Hello @RAW333


Please let us know if the information provided by @rpvw resolved the issue, otherwise any further information you can provide including screenshots would be helpful.

Thanks!
 

Raw333

Member
Jan 8, 2019
10
3
3
US
cPanel Access Level
Root Administrator
Thanks for replying, but I see no options for setting privileges when I create the DB and after DB has been created... I did create a user... but user has 'no privileges'

I'm sure the solution here is simple, I'm just not seeing it.
 

Attachments

rpvw

Well-Known Member
Jul 18, 2013
1,101
465
113
UK
cPanel Access Level
Root Administrator
Your database mcmlogor_site has no user assigned to it

Add the user mcmlogor_rawuser to the database mcmlogor_site and follow the instructions !
 
  • Like
Reactions: cPanelLauren