MySQL Restricting access by hostname/IP?

[arpoodle]

I've set up MySQL to replicate from the server running ISPCP to my backup system in my local office.

To enable external access to MySQL, I've had to comment out the "bind-address = 127.0.0.1" setting, which means anyone can try and connect from anywhere now.

Obviously, MySQL has it's own hostname based authentication, but I'd much rather prevent any connections from any other host/IP other than my own local one.

Is there a way, within ISPCP to restrict access based on IP, or do I need to do it manually somehow?

tia

a

[kilburn]

You will need to do it on your own (probably using iptables).

[fluser]

You can restrict access to MySQL with MySQL-Onboard-Tools. You can change the user table with PMA and reload the permissions of MySQL.

Best Regards
Fluser