phpMyAdmin, ‘Error #2002 - The server is not responding’, and OS X 10.4.4

Trying to install phpMyAdmin on a fresh OS X 10.4.4 install this afternoon was an incredible exercise in frustration. No matter what I did I kept getting the dreaded ‘Error 2002 - The server is not responding‘ error. Turns out the the location of mysql.sock has changed in this version of OS X; if you had all this working before upgrading then the OS was smart enough to detect it and create a sym link to the new location. However new installs, not so much.

Worked for me:

Open a terminal, type in

# ls -al /etc/php.ini*

If a php.ini does not exist copy over the default php.ini,

# cp /etc/php.ini.default /etc/php.ini

Now edit the php.ini

# nano /etc/php.ini (or use your prefered editor)

Find “mysql.default_socket” (you can search using [Ctrl]+[w] in nano)

Enter “/tmp/mysql.sock” after the equals sign.

Don’t forget to save the file ([Ctrl]+[o] [Enter] in nano)

Now restart Apache

# apachectl graceful

PHPMyAdmin :: Cannot start session without errors

If you are getting the following error in the phpMyAdmin on cpanel server

Error: Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

Solution:: Then follow these steps.

1) Login in to the Shell with the root user and then open the file using your favorite editor .

vi /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini

2) Search for [Session] and change the following

FROM:
-----
session.save_handler = sqlite
session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb
-----
TO
-----
session.save_handler = files
session.save_path = /tmp
-----

and then save and Exit .

3) Restart Apache server using command

/etc/init.d/httpd restart