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.

 
Go Back  dBforums > Database Server Software > MySQL > /tmp/mysql.sock Problem: Not There (Mac OS X)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-16-04, 21:08
libsys libsys is offline
Registered User
 
Join Date: Jan 2004
Location: Illinois
Posts: 4
/tmp/mysql.sock Problem: Not There (Mac OS X)

Hello All,

I'm a total newb with Mac OS X, and a total new w/installing MySQL. That being said, when I installed MySQL initially today, it seemed to work just fine. Having shut off my computer to do some other stuff, I am now getting the following error:

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

So, it would seem that this file must exist in order for MySQL to work, but it's not there. I read that this might be due to a cron job that automatically cleans out the tmp folder, which makes sense. The only items I see in the tmp directory are 501 and mcx_compositor (file).

Any suggestions?...especially basic ones?

Oh, yes, I should also mention that my Mac help application stopped working. Spiffy...perhaps unrelated but i thought I'd just mention that.

Thanks!!!!!
Reply With Quote
  #2 (permalink)  
Old 05-17-04, 23:44
J.D. J.D. is offline
Registered User
 
Join Date: May 2004
Location: NJ USA
Posts: 21
When you started your computer, did you remember to start the mysql server (mysqld) ?
__________________
J.D.
Database Administrator
Reply With Quote
  #3 (permalink)  
Old 05-18-04, 12:11
libsys libsys is offline
Registered User
 
Join Date: Jan 2004
Location: Illinois
Posts: 4
Thanks: somehow resolved.

First, thanks J.D. for your gracious reply. The thing is, I set up the auto start feature (or whatever it's called) to start the mysql server along with the computer. But I tried your suggestion anyway, and it told me the port was already in use (i.e. the server had been started).

I had created a symbolic link to /private/tmp yesterday but had not been able to see if that worked just then...apparently it did, because mysql starts right up now.

Incidentally, here is where I found this fix:

http://www.iwalt.com/weblog/2003/01/mysqlsnafu

And check out this comment:

"Hey man. Safari is causing the problems with tmp folder. See macfixit.com. Seems it likes to delete it, and sometimes the home directory? Anyway, just do a little "ln -s /private/tmp /tmp"
Daniel

-Yikes, that sucks.

But thanks again for your response, I appreciate your taking the time.

-Chad
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting 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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On