January 8, 2003

MySQL Snafu

Somehow my local copy of MySQL has become fubared. Has anyone else experienced this? I’m consistently getting an error which reads, “Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)”. I’m using Marc Liyanage’s MySQL installation which until this evening was working fine so far as I was aware. Thanks in advance for any light which might be shed.

[Update: I’m starting to think that the /tmp/mysql.sock communication socket was somehow deleted since there’s no file by that name. I’ve tried reinstalling the MySQL package. No dice. Grr.]

[Progress: I think I’m starting to get my mind around what went wrong. Somehow the pointer for /tmp -> /private/tmp was replaced by a /tmp directory. I have no idea what did that but I’d sure like to find out. I’m going to try to figure out how to remove the new directory and restablish the pointer.]

[Fixed: So replacing the directory with a symbolic link (essentially, restoring it to the way it should be) seems to have repaired the problem and enabled MySQL (and probably other apps which use /tmp) to run properly again. What a pain.]

Previous Post
Next Post