I need a user who creates databases and permissions to other users.
I've tried
and works temporarily, for some reason WHM clears those permissions from time to time.
I even make a cron that run the command daily
but WHM is also cleaning up this cron periodically.
I also ran the command
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?
I've tried
Code:
GRANT ALL PRIVILEGES ON *. * TO 'myuser' @ 'localhost' WITH GRANT OPTION;
I even make a cron that run the command daily
Code:
mysql -e "GRANT ALL PRIVILEGES ON *. * TO 'myuser' @ 'localhost' WITH GRANT OPTION;"
I also ran the command
Code:
/usr/local/cpanel/bin/dbstoregrants username
How to effectively create a user with GRANT OPTION in WHM?