Remote MySQL connect

Martin Marcher martin.marcher at
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 ! -j DROP

something like that has a bunch of good examples for  
those kind of stuff (and also gives some insight what you are really  
doing there)


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 -
> 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 Can this be  
> done via
> MySQL's config or must it be done via the firewall and removing bind-
> address?
> -- 
> Best,
> Marc
> -- 
> ubuntu-users mailing list
> ubuntu-users at
> Modify settings or unsubscribe at: 
> listinfo/ubuntu-users

More information about the ubuntu-users mailing list