Allow only remote mysql ip address

KV Karia

• February 24, 2017 01:40

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

  • February 24, 2017 18:14

  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.

  0
• 

  iserversupport

  • February 24, 2017 19:41

  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"

  0

Please sign in to leave a comment.