[plug] mysql server

[Russ Powers]

I just found it. In my.cnf it had skip-networking. I just commented it out and 
it works now. Must have read that file ten times and didn't notice.

Thanks for the help Brad, James, and Tom. 

On Wed, 22 Sep 2004 04:26 pm, Brad Campbell wrote:
> 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 defaul
>
> Regards,
> Brad
> _______________________________________________
> PLUG discussion list: plug at plug.linux.org.au
> http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au

-- 
Regards,
Russ