Remote MySQL privileges error

[Samaras Orestis]

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

 

[MilesWeb]

Hi there. Did you check the logs & see if any errors are being polled when assigning the privileges to MySQL user ?

 

[Samaras Orestis]

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

 

[cPanelMichael]

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.

 

[Samaras Orestis]

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

 

[cPanelMichael]

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!

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.