Remote MySQL Access Hosts not adding to the list.

[bigtomjp]

I have added the hosts to WHM in Additional MySQL Access Hosts and selected to setup cPanel user account with those hosts. As well I have added tried to add the same hosts to the access list in Remote MySQL. I get a confirmation that the host was added to the list but it never actually adds them.

I have a second server that works exactly as expected. The only difference is the one with issues is using MariaDB 10.1. From what I have seen this should still be fully compatible with remote access.

WHM 54.0 (build 21)

 

[bigtomjp]

Forced reinstall of WHM 54 but still had the issue. Moved to the Edge WHM 55 and problem is fixed. I think there was a problem with the install and the Forced installation did not actually change everything. Sadly I cannot return to 54, but it was a better solution that wiping the server.

 

[cPanelMichael]

Hello

The issue you have described is a known bug, and was addressed in cPanel version 56 with this case:

Fixed case CPANEL-4554: Work around MariaDB 10.1 password bug.

Thank you.

 

[bigtomjp]

Thank you for letting me know. I thought I was going crazy.

 

[bigtomjp]

Any estimated time when 56 will move out of EDGE.

 

[cPanelMichael]

Any estimated time when 56 will move out of EDGE.

It's tentatively scheduled for publication to the "Current" build tier next week, but we do not guarantee specific release dates due to the potential for unforeseen circumstances.

Thank you.