The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Remote MySQL privileges error

Discussion in 'Database Discussions' 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:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi there. Did you check the logs & see if any errors are being polled when assigning the privileges to MySQL user ?
     
  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:
    30,678
    Likes Received:
    649
    Trophy Points:
    113
    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.
     
  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:
    30,678
    Likes Received:
    649
    Trophy Points:
    113
    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.
     
Loading...

Share This Page