Re: OT: Mysql problem

[Elizabeth Barham <soggytrousers@yahoo.com>]

Shawn Dunn <sfalken@dumpsterdivers.net> writes:
> 
> root@p-120:/usr/local/mysql# mysql -u root -p
> Enter password:
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/var/run/mysql/mysql.sock' (111)
> root@p-120:/usr/local/mysql#

That is a connection refused error (111).

On Debian, the config file is at:

/etc/mysql/my.cnf

I was taken for a surprise that the Debian distribution came with
these lines in my.cnf:

# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking

Anyway, after commenting out 'skip-networking' I could connect from a
remote host.

That may not be the exact same problem you are having but perhaps it
is something similar?

Elizabeth