Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Create a new MySQL user with super privileges

Discussion in 'Database Discussion' started by Gustavo Vendramini, Mar 19, 2019.

  1. Gustavo Vendramini

    Gustavo Vendramini Registered

    Joined:
    Mar 19, 2019
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    I need a user who creates databases and permissions to other users.

    I've tried
    Code:
    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
    Code:
    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
    Code:
    /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?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Gustavo Vendramini likes this.
  3. Gustavo Vendramini

    Gustavo Vendramini Registered

    Joined:
    Mar 19, 2019
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    @cPanelMichael

    Your Support Request ID is: 11751097
     
    cPanelMichael likes this.
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice