Results 1 to 8 of 8
  1. #1


    Member Since
    Sep 24, 2008
    Posts
    8
    Unhappy cant restart mysql
    Hi I am trying to start mysql on my server and its not starting gives me the following error message

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/private/var/mysql/mysql.sock' (38)

    I have checked etc/my.cnf and it has

    socket = /private/var/mysql/mysql.sock

    i have checked php.ini.default and php.ini and they have

    mysql.default_socket = /private/var/mysql/mysql.sock

    I type locate mysql.sock
    and it gives

    /private/var/mysql/mysql.sock

    any ideas what on earth is going on here?
    i don't understand what is going on

  2. #2

    Dysfunction's Avatar
    Member Since
    Mar 17, 2008
    Location
    Tucson, AZ
    Posts
    6,821
    Specs:
    Way... way too many specs to list.
    what happens when you issue..

    mysql_config --socket

    ?
    mike
    This machine kills fascists
    Got # ? phear the command line!

  3. #3


    Member Since
    Sep 24, 2008
    Posts
    8
    if i type mysql_config --socket i get

    /var/mysql/mysql.sock

  4. #4

    Dysfunction's Avatar
    Member Since
    Mar 17, 2008
    Location
    Tucson, AZ
    Posts
    6,821
    Specs:
    Way... way too many specs to list.
    Try changing the my.cnf to point to that as your socket
    mike
    This machine kills fascists
    Got # ? phear the command line!

  5. #5


    Member Since
    Sep 24, 2008
    Posts
    8
    I tried that it just gives

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

  6. #6


    Member Since
    Sep 24, 2008
    Posts
    8
    I solved it the disk was full lol i had to remove a 29GB log file and reboot the server and hey presto mysql restarted. The lesson to be learnt is before you start playing around with config files check your hard disk space.

  7. #7

    Dysfunction's Avatar
    Member Since
    Mar 17, 2008
    Location
    Tucson, AZ
    Posts
    6,821
    Specs:
    Way... way too many specs to list.
    yea, I've done that more than once.. a df would have saved me some time in the past
    mike
    This machine kills fascists
    Got # ? phear the command line!

  8. #8


    Member Since
    Oct 13, 2009
    Posts
    1
    MySQL not starting
    Can someone tell me which mysql files I can remove in order to start mysql. I removed the two log files but I still can't restart mysql.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mySQL
    By burnedfaceless in forum Web Design and Hosting
    Replies: 1
    Last Post: 02-03-2014, 09:36 AM
  2. mysql on mac
    By ytbryan in forum OS X - Apps and Games
    Replies: 0
    Last Post: 05-19-2009, 04:51 PM
  3. need to stop sleep - sleep & restart - restart etc
    By billie1 in forum OS X - Operating System
    Replies: 2
    Last Post: 12-18-2008, 09:40 AM
  4. Replies: 17
    Last Post: 12-10-2007, 11:03 PM
  5. MySQL
    By ftjogoh in forum Web Design and Hosting
    Replies: 3
    Last Post: 11-21-2004, 12:29 PM

Posting Permissions

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