Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Developer Center > mysql problem and solution

mysql problem and solution
Thread Tools
fc_
Fresh-Faced Recruit
Join Date: Apr 2004
Status: Offline
Reply With Quote
May 12, 2004, 11:26 AM
 
Recently, out of the blue, my installation of mysql suddenly stopped working. The daemon was dying with the error of

Code:
040512 04:32:11 mysqld started 040512 4:32:12 Can't start server : Bind on unix socket: Permission denied 040512 4:32:12 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 040512 4:32:12 Aborting
After backing up my data directory for mysql, and reinstalling mysql several times, the error persisted. Upon further investigation, the /tmp directory (where mysql keeps its lock file) had somehow become a standard directory, rather than a symbolic link to /private/tmp/

Deleting the offending tmp directory, and reestablishing the symbolic link, finally fixed the problem.

Anyway, just wanted to pass this on, in case this ever happens to you.

[ps... and no, mysqld wasn't already running, and there was no mysql.sock file in the hosed tmp directory, that's the first thing that I looked for]
     
genevish
Mac Enthusiast
Join Date: Jan 1999
Location: Marietta, GA, USA
Status: Offline
Reply With Quote
May 12, 2004, 01:19 PM
 
I'd be interested to know why the tmp directory changed. Some other software you installed maybe?
Scott Genevish
scott AT genevish DOT org
     
fc_  (op)
Fresh-Faced Recruit
Join Date: Apr 2004
Status: Offline
Reply With Quote
May 12, 2004, 02:17 PM
 
Really not sure. Haven't installed any new software (aside from a recent security update, but even that was a while ago) that should have even touched the /tmp directory.
     
   
Thread Tools
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 04:32 AM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,