Create a new MySQL user with super privileges

[Gustavo Vendramini]

I need a user who creates databases and permissions to other users.

I've tried

GRANT ALL PRIVILEGES ON *. * TO 'myuser' @ 'localhost' WITH GRANT OPTION;

and works temporarily, for some reason WHM clears those permissions from time to time.

I even make a cron that run the command daily

mysql -e "GRANT ALL PRIVILEGES ON *. * TO 'myuser' @ 'localhost' WITH GRANT OPTION;"

but WHM is also cleaning up this cron periodically.

I also ran the command

/usr/local/cpanel/bin/dbstoregrants username

after change the grants on yaml files in /var/cpanel/databases/ and it did not work.

How to effectively create a user with GRANT OPTION in WHM?

 

[cPanelMichael]

Hello @Gustavo Vendramini,

Can you open a support ticket so we can take a closer look at your system to see why privileges are not retained? You can post the ticket number here and we'll link this thread to it.

Thank you.

 

[Gustavo Vendramini]

Hello @Gustavo Vendramini,

Can you open a support ticket so we can take a closer look at your system to see why privileges are not retained? You can post the ticket number here and we'll link this thread to it.

Thank you.

@cPanelMichael

Your Support Request ID is: 11751097

 

[cPanelMichael]

Hello,

To update, it looks like the advice in the support ticket was to create a reseller with root privileges in order for it to setup the necessary MySQL grants. Can you confirm if this advice was suitable for what you're looking to do?

Thank you.