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