These are the steps I followed to install phpMyAdmin on my local machine, which is a MacBook Pro.  Substitute your own user name for “franz”.

• Download the zip file from http://www.phpMyAdmin.net .  I downloaded version 2.11. Although there is a later version.
• After Unzipping the file, I copied the folder to my Sites directory under /users/franz/sites
• Using the finder, I navigated to those files, and created a folder called config in the phpMyAdmin folder.  I then set the write permission to read/write for that folder
• I renamed the config.sample.inc.php by adding .bak, since I will be creating a new file with this name.
• I started the configuration program by opening up a browser and entering:

http://localhost/~franz/phpMyAdmin/scripts/setup.php

• I clicked under Servers the “Add” button
• The only item I entered was the root password for the MySQL installation I had done
• Click Add
• On the next screen, make sure you click the “Save” under the Configuration section
• This created a new file in the folder I created called “Config”.  I copied that file up to the parent directory and then deleted the Config folder.
• I tried to start by entering the browser: http://localhost/~franz/phpmyadmin/
• I had this error, which can happen on a Mac because it is looking for a file that has been moved to a new location.

• To solve this, I openned up the terminal window and after loggin in entered the following commands:

sudo mkdir /var/mysql

sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

• I was then able to run phpMyAdmin by entering this into the browser

http://localhost/~franz/phpMyAdmin/

• I then downloaded version 3 of phpMyAdmin and found the setup is a bit different.  You still have to create the config folder and make it read/write.
• To configure use this URL instead:

http://localhost/~franz/phpMyAdmin/setup

• Create a new server as shown above and then be sure to save the configuration.

Categories: Web Development
1 Comment »