Allow only remote mysql ip address

KV Karia

Member
Jul 3, 2015
11
1
3
Rajkot
cPanel Access Level
Root Administrator
I want to setup whm to allow only those remote ip addresses other than localhost to connect mysql who added in cpanel by user in Remote Mysql

TCP-IN Port 3306 allowed in Firewall but TCP-OUT is blocked.

But currently, all IPs can able to connect mysql database even not added in Remote MySQL in cpanel.

If I add bind-address=127.0.0.1 in my.cnf than connection not allowed by any ip even added in cPanel Remote MySQL
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
But currently, all IPs can able to connect mysql database even not added in Remote MySQL in cpanel.
Hello,

Could you verify the steps you are taking to reproduce this?

Thank you.