How to access mysql server on network server ?
 

Hi chaps,

I've got a debian woody server working on my network with the following adress 192.168.0.200
A mysql server is installed on it. ( i can access it remotely with phpmyadmin )
Every pc on the network is dhcp configured.

When using Mysql Query Browser or EMS Sql Manager, it says that it cannot connect to mysql server to obtain database list.

How can i configure for this server to be accessible via port 3306 ?

Regards,

pierre

First things first, determine which ip the server was assigned (ifconfig). Then check the firewall on the server to see that 3306 is open (iptables -L). Use a client (or the command line) on the server itself and make sure the mysql user you are using to connect has an entry for remote (user@% or user@<remoteip>. Once you have checked these out, try to connect again from a remote machine.

Mysql usually ships with local access only for its default users (like root) as a security measure. You have to enable remote access for each user you want to allow to connect remotely.

Done !
Tks for the tips ... i've checked everything as well as a file named /etc/mysql/my.cnf
I've comment out line skip-networking
Works fine now !