MySQL Error #2002 with PHPMyAdmin on Mac OS X 10.5 Leopard

November 3, 2008 | 8 Comments |

Attempting to login to my local installation of PHPMyAdmin on Mac OS X Leopard for the first time, I received this message:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Assuming the server is installed and running, these problems are almost always caused by incorrect path issues. A Google search brought up this solution.

Solution:

  1. Open the terminal
  2. sudo mkdir /var/mysql
  3. sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
  4. Reload the login page and login

Solution found on Friends of Ed forum.

| Tags: Apple, Databases

8 Comments

  1. Angelina spake saying:

    Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you!!!!!!

    November 4th, 2008 at 12:12 pm
  2. may spake saying:

    thanks!!

    November 11th, 2008 at 4:55 am
  3. sven spake saying:

    yeah, you are hero!!!!! thanks alot :)

    November 20th, 2008 at 2:53 pm
  4. mentha spake saying:

    Finally a solution that actually works!!!! *hail*

    December 2nd, 2008 at 12:54 pm
  5. James Welz spake saying:

    PHPMyAdmin 3.1.1 error Cannot modify header information – headers already sent by (output started at /Library/WebServer/Documents/phpMyAdmin/libraries/Error.class.php:357) in /Library/WebServer/Documents/phpMyAdmin/libraries/header_http.inc.php on line 22 HELP!!!

    December 18th, 2008 at 11:04 am
  6. Harry spake saying:

    Try searching Google for “PHPMyAdmin Cannot modify header information”. There are quite a few results.

    December 18th, 2008 at 12:50 pm
  7. Installing PHP with GD Library & MySQL on Mac OS X Leopard 10.5x at Here & there… spake saying:

    [...] And if you find any trouble logging in to phpMyAdmin interface, here is another lines of codes for Terminal at  http://harrylove.org/2008/11/03/mysql-error-2002-with-phpmyadmin-on-mac-os-x-105-leopard [...]

    January 31st, 2009 at 6:46 am
  8. Asni spake saying:

    thankyou thankyou thankyou thankyou thankyou thankyou thankyou…

    though at the moment I have PhpMyAdmin 2.something installed, has anyone figured out how to make the newest version work yet?

    :D

    February 12th, 2009 at 5:25 pm