Remote MySQL Access Hosts not adding to the list.

bigtomjp

Member
Apr 6, 2016
13
1
3
cPanel Access Level
Root Administrator
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

Member
Apr 6, 2016
13
1
3
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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.