On Sat, 8 Nov 2003, Michael Satterwhite wrote: > This has got to be a common question, but I'd really appreciate a little help. > > I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run > that deletes this. > > When I try to start mysql, I get the message > > "Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2)" > > Using locate, I see that, indeed, it is not there. I'm using MySQL 4.1.0 > > I've tried running mysqld_safe. It tries to start the mysqld, then I > immediately get the message that mysqld ended. It doesn't start. > > How do I get it going again?
If your server is not running (check with a `ps -aux` call) then check your error logs. If the server IS running however, it's likely that your client tries to connect through /var/lib/mysql/mysql.sock while the server listens somewhere else. To find out if that is the case, run `netstat -u | grep "mysql.sock"` and see where the server is listening. If the server is listening on, for example /tmp/mysql.sock , then you can make your client use that by editing your ~/.my.cnf (or /etc/my.cnf, or any of the other locations possible) with the row socket = /tmp/mysql.sock under the [client] group (or change the server's by entering the same row with the other path under the [mysqld] group). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
