Remote MySQL connect
martin.marcher at openforce.com
Tue Dec 12 14:13:40 UTC 2006
I'd do it via a firewall (since this is the only way I know for
mysql, but then again I don't like mysql - someone may know better)
iptables -I INPUT -t filter --source-addres ! 192.168.0.1 -j DROP
something like that netfilter.org has a bunch of good examples for
those kind of stuff (and also gives some insight what you are really
Am 12.12.2006 um 13:10 schrieb marc:
> What is the 'correct' way to configure MySQL for remote connections?
> The db in question is running fine and can be accessed via phpmyadmin,
> amongst other things.
> The default my.cnf has:
> bind-address - 127.0.0.1
> When I comment this out (and restart the db), I can connect remotely -
> so user/password and privs are fine) but this leaves the db wide open.
> Say I want to provide remote access to 192.168.0.1. Can this be
> done via
> MySQL's config or must it be done via the firewall and removing bind-
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/
More information about the ubuntu-users