[plug] mysql server

[Shayne O'Neill]

For what its worth Russ, that "skip networking" one gets me every time I
install mysql and everytime I forget and spend 15+ minutes in utter
frusturation till I remember. :)

--
"Well, I think if you say you're going to do something and don't do
it, that's trustworthiness."
-- George Bush on CNN online chat, Aug.30, 2000
RIAA Copyright notice trap: http://guild.murdoch.edu.au/~shayne/

On Wed, 22 Sep 2004, Russ Powers wrote:

> 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
> _______________________________________________
> 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
>