Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Illinois
    Posts
    4

    Unanswered: /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!!!!!

  2. #2
    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

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •