Remote MySQL connect

[Martin Marcher]

Hello,

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  
doing there)

hth
martin

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-
> address?
>
> -- 
> Best,
> Marc
>
>
> -- 
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/ 
> listinfo/ubuntu-users
>