Install phpMyAdmin 3.3.10 on Mac OS X Snow Leopard 10.6.7

1. Go to http://www.phpmyadmin.net and download the latest version. I got the phpMyAdmin-3.3.10-english.tar.gz  file.

2. Copy to somewhere you'll remember and unzip it.

     Make sure that folder is accessible to your local web server. ie, copy it to your Sites folder so you have ~user/phpMyAdmin-3.3.10-english

3. Browse to that site. ie.  http://localhost/your_folder/phpMyAdmin-3.3.10-english

You'd probably want to change the name of that folder..

When I first tried to log in as root I got this error:

#2002 Cannot log in to the MySQL server

So.. In /etc/php.ini, replace the three occurrences of /var/mysql/mysql.sock by
/tmp/mysql.sock

prompt# chmod u+w php.ini

 

find:  pdo_mysql.default_socket=/var/mysql/mysql.sock

change to: pdo_mysql.default_socket=/tmp/mysql.sock

find: mysql.default_socket = /var/mysql/mysql.sock
change to:  mysql.default_socket = /tmp/mysql.sock

find: mysqli.default_socket = /var/mysql/mysql.sock
change to:  mysqli.default_socket = /tmp/mysql.sock

  Now I get this error:

phpMyAdmin -

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

back to php.ini and uncomment the session.save_path

; http://php.net/session.save-path
session.save_path = "/tmp"
 

Close out programs and restart apache

prompt# apachectl restart

Now its working. Still get some warnings but I can do what I need to do..

4. Log in as your mysql root with your password credentials for the first time.

5. First thing you need to do is setup a user account for normal database creation and usage..

    You should setup more accounts for appropriate levels of access..

Good to go.  Check out the forums if you need any help.