ispCP - Board - Support
MySQL Restricting access by hostname/IP? - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: MySQL Restricting access by hostname/IP? (/thread-12382.html)



MySQL Restricting access by hostname/IP? - arpoodle - 12-08-2010 08:43 PM

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


RE: MySQL Restricting access by hostname/IP? - kilburn - 12-09-2010 03:33 AM

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


RE: MySQL Restricting access by hostname/IP? - fluser - 12-09-2010 06:16 AM

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