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!

Remote MySQL privileges error

Discussion in 'Database Discussion' started by Samaras Orestis, Jan 25, 2016.

  1. Samaras Orestis

    Samaras Orestis Registered

    Joined:
    Jan 25, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    Hello all,

    I have two hosts (VPS - Centos 7), one running the "main" web/mail server (with cPanel/WHM 11.52 installed) and the other running a MySQL instance only (no cPanel on this one). I have setup the main host (through SQL Services >> Manage MySQL profiles), to use the remote MySQL, and the profile creation and activation was successfull.

    Now, when creating a database, or a user for a specific database, all changes are reflected to the MySQL host (database created and user added) but the user only has usage privileges, no matter what privileges I have selected when creating the database user through cPanel. Moreover, even though the user appears on the MySQL users section, there is no record on the "Privileged users" column of the MySQL databases table section.

    I 've searched both cPanel and MySQL documentation and the web in general, for any clues on this, but nothing showed up.

    Any help would be much appreciated!
    Thanks in advance
     
  2. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    173
    Likes Received:
    2
    Trophy Points:
    68
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi there. Did you check the logs & see if any errors are being polled when assigning the privileges to MySQL user ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Samaras Orestis

    Samaras Orestis Registered

    Joined:
    Jan 25, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    Hello,

    Unfortunately there are no errors, except that main cPanel services (i.e. cPHulk) are not allowed to access the server (due to privileges errors).

    If I grant the required privileges manually, everything works great, but this is obviously not an option.

    Is there any other possible lead? Please do not hesitate to ask for more info if you believe it could help clarify this issue...

    Once again, thank you
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,277
    Likes Received:
    1,846
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Samaras Orestis

    Samaras Orestis Registered

    Joined:
    Jan 25, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    Hello all,

    The problem was an unsupported version of MySql (5.7) and more specifically the password validation plugin which blocked the cPanel user account creation.
    Switched to MariaDB 10.1 and everything now runs smoothly!

    There is an internal case (not sure if I am supposed to post its ID here) about how cPanel handles unsupported versions of MySQL and it will be added to the changelog as soon as it's resolved.

    Thank you all for your time.
    Best ;)
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,277
    Likes Received:
    1,846
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    I am happy to see the issue is now resolved. Thank you for updating us with the outcome. Note that I believe the internal case you are referring to is:

    Fixed case CPANEL-3692: Fix MySQL version parser for Percona server versions.


    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