I think it is running, but clients try to connect to different socket
file than what the server is using. Either change file for server or
change it for clients. Or something has deleted the socket file. Read
more from:
can you tell me.. is the mysql.sock suppose to me listed in my /tmp
directory? I followed the web source you directed me to. The "t" bit
on this directory has been set so no cron can remove mysql.sock as
suggested in the info related to my problem.
[craig@localhost craig]$ mysqladmin -h `hostname` version
mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.0-alpha
Protocol version 10
Connection localhost.localdomain via TCP/IP
TCP port 3306
Uptime: 4 days 1 hour 19 min 47 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000
Above is the output of one of the suggested commands. It would
appear that I "don't" have a socket connection, but rather a TCP/IP
connection. My understanding is that it should be a sock connection
based on the fact that I'm trying to access mysql server from
the very machine that it is running on.
What should I be trying to do here to get something like
<./bin/mysqladmin create testDB > to work
any suggestions
thank you
craig