[plug] mysql server

[Russ Powers]

On Wed, 22 Sep 2004 05:07 pm, James Devenish wrote:
> In message <200409221700.43688.russ at powerstech.com>
>
> on Wed, Sep 22, 2004 at 05:00:43PM +0800, Russ Powers wrote:
> > telnet: Unable to connect to remote host: Connection refused
>
> Okay, then, I think the problem is along the lines of what Brad and I
> have described. The first question is whether MySQL is listening with
> "TCP" or whether it is only using "UNIX sockets".
>
> > Linux 2.4.26 (Libranet).
>
> I do not use Libranet, so I am not sure what instructions to give you.
> If is possible that you have a file called 'my.cnf' on your system.
> Perhaps it is at /etc/my.cnf or /etc/mysql/my.cnf or similar. Try

Spot on James. Ran netstat like Brad said and there was nothing. Had a look in 
my.cnf and commented out the skip-networking setting and it works now.

Thanks guys.

> `locate /my.cnf` if you are unsure -- I get the feeling you already know
> this file, since you have already mentioned a 'port' setting. Have a
> look under '[mysqld]' section in that file. Does it mention anything
> about "binding" to "lo"? If so, remove that. I think mysqld will then
> listen of all available interfaces. If this is not your problem, it is
> also possible that a firewall is causing the problem. Did Brad's netstat
> command yield any insights so far?
>
>
> _______________________________________________
> 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