[plug] mysql server

Brad Campbell brad at wasp.net.au
Wed Sep 22 16:26:05 WST 2004


Russ Powers wrote:
> Hi,
> 
> I've got mysql server running on one machine on my lan and I'm trying to get 
> to it from another machine on my lan. Mysql variables shows port 3306. I keep 
> getting the error message:
> 
> ERROR 2003: Can't connect to MySQL server on '192.168.1.92' (111)
> 
> I can use mysql on the same machine with no problems. And I can use phpMyAdmin 
> from the other machine.
> 
> I've looked at the mysql.log, mysql.err log, messages, and syslog and there 
> isn't any reference to the login attempts.
>  
> I would guess that the server is just not listening? Is there any way to find 
> out for certain? And if not, any idea why it's not listening?

netstat -na | grep 3306 will tell you if its listening. Some distributions disable external binding 
by default.

Regards,
Brad



More information about the plug mailing list