Allow only remote mysql ip address

[KV Karia]

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]

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.

 

[iserversupport]

You can achieve this by closing mysql port in csf conf and allow only necessary IP's using the command

csf -a "tcp|in|d=3306|s=IP.IP.IP.IP"