An associate has asked me to take a look a problem he's having with starting
mysql. I thought I'd give it a shot to learn some more about mySQL before
having him turn it over to someone more knowledgeable than I. But I have to
ask here first.
Attempting to connect to the database via mysqladmin or mysql results in the
error (paraphrased) "Cannot connect to local database using socket
"/var/lib/mysql/mysql.sock".
That is the path to the socked specifiet in both mysqld and client sections
of the my.cnf.
mysqladmin -h `hostname` version shows that the Connection is via TCP/IP
rather than Unix Sockets.
Running on Redhat Linux AE 3 (I think)
/var/lib/mysql is world-writable-readable, but it is not owned by user mysql
(my next attempt to fix this)
/var/lib/mysql/mysql.sock is 777.
My question: What would be causing mysqld to be using TCP rather than Unix
sockets? I've checked permissions, verified settings in my.cnf (which is
very sparse... other entries are for logging), confirmed mysqld is running
and accessible via TCP/IP.
I'm fishing for clues. Any help appreciated.
- Virgil