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!

Granting super priviledges

Discussion in 'Database Discussion' started by RAW333, Feb 7, 2019.

  1. Raw333

    Raw333 Member

    Joined:
    Jan 8, 2019
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    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!
     
  2. Eminds

    Eminds Well-Known Member

    Joined:
    Nov 10, 2016
    Messages:
    312
    Likes Received:
    28
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    have you created DB user for the database ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Raw333

    Raw333 Member

    Joined:
    Jan 8, 2019
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    US
    cPanel Access Level:
    Root Administrator
    yes, I'm familiar with the process of setting up DBs... I see no options for privileges now.
     
  4. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    1,088
    Likes Received:
    441
    Trophy Points:
    113
    Location:
    Spain
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelLauren likes this.
  5. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,734
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Raw333

    Raw333 Member

    Joined:
    Jan 8, 2019
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    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.
     

    Attached Files:

  7. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    1,088
    Likes Received:
    441
    Trophy Points:
    113
    Location:
    Spain
    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 !
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelLauren likes this.
  8. Raw333

    Raw333 Member

    Joined:
    Jan 8, 2019
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    US
    cPanel Access Level:
    Root Administrator
    I knew it was simple... gosh.
     
    cPanelLauren likes this.
  9. Raw333

    Raw333 Member

    Joined:
    Jan 8, 2019
    Messages:
    8
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    US
    cPanel Access Level:
    Root Administrator
    Thank for your help!
     
    cPanelLauren likes this.
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