SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    What's HTML?
    Join Date
    May 2001
    Location
    San Diego, CA
    Posts
    1,701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Not connecting through socket

    I finally got MySQL up on the RaQ4, now I went to login and I got this error:
    ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

    I opened up that file and it's completely blank. Now what did I do wrong?
    Ryan Kuhle - A Proud Advisor - Got Questions? Just Ask!
    Get your website started for less than $20! Click Here

  2. #2
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your mySQL server is either a) not running or b) not accepting connections.

    Verify that it's running and try connecting through the 'mysql' commandline utility.

  3. #3
    What's HTML?
    Join Date
    May 2001
    Location
    San Diego, CA
    Posts
    1,701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It must not be accepting connections. I just tried starting the MySQL server but it responded and said a mysqld process is already running. Now what?
    Ryan Kuhle - A Proud Advisor - Got Questions? Just Ask!
    Get your website started for less than $20! Click Here

  4. #4
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    First, shut down all the mysql processes. This can be done with mysqladmin, or my preferred method, 'killall mysqld'.

    Then, start safe_mysqld up again. Don't forget the &.

    Then try connecting. You can see if mysql is listening by doing 'netstat -a|grep 3306'. If there's something there, then mysql is listening on that port.

    I assumed you're doing this from the commandline--is that the case?

  5. #5
    What's HTML?
    Join Date
    May 2001
    Location
    San Diego, CA
    Posts
    1,701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ah, got it. Thanks Quinn.
    Ryan Kuhle - A Proud Advisor - Got Questions? Just Ask!
    Get your website started for less than $20! Click Here


Bookmarks

Posting Permissions

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