iptables and mysql...

[MKlinke]

On Friday 02 July 2004 08:34, bruce wrote:
> hi...
>
> i'm investigating what needs to be done to allow mysql on a server
> to be used remotely by client machines. each machine is running
> iptables. so i'm wondering what has to be in the iptables for the
> machine being used as the mysql server, as well as the client
> machines that will be communicating with the mysql box...
>
> also, how would i test that the iptable/mysql configuration setup
> is working properly...
>
> i have rh8.0 and mysql v11.18-dist3.23.54
>
> any pointers/comments/criticisms or actual iptable configs
> illustrating this would be extremely helpful!!!
>
> thanks
>
> -bruce

Once you have a database up an running on your database server you 
need to make sure that iptables allows connection to port 3306 of 
your server.

Assuming that you have the mysql-client software installed on your 
client machine you can then log into your server with the mysql 
program; i.e.

mysql -u <username> -p -h <ip_address_of_server>
Enter password:

and voila! you're in.

Regards,  Mike Klinke