mysql -- Anybody want to guess at this one?

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: David A. Sinck
Date:  
Subject: mysql -- Anybody want to guess at this one?

\_ SMTP quoth Roderick Ford on 3/29/2002 13:03 as having spake thusly:
\_
\_ any mysql commands to connect or get status (i.e. mysqladmin version)
\_ produce the following two lines:
\_
\_ ERROR 2002: Can't connect to local MySQL server through socket
\_ '/var/lib/mysql/mysql.sock' (2)
\_
\_
\_ chkconfig shows mysqld is on
\_ ps -el shows safe_mysqld and mysqld are running
\_
\_
\_ perhaps mysql.sock did not get opened ??
\_ or, vmware interferes ??
\_ or...
\_
\_ i'm at a loss...what do you think I should check? it used to work.

check for a /etc/my.cnf; it might specify an alter local socket or
other amusements;

make sure that /var/lib/mysql/mysql.sock exists and looks pipish.

I think the build docs someplace say how you can build mysql without
local unix sockets.

Try connecting ala:

mysqladmin -h 127.1 -u root -p ....

And see if the network version is alive and kicking.

David