Welcome to part 3 of the MAMP tutorial. In this post we will go over setting up phpMyAdmin on your Mac’s localhost. Part 2 walks you through installing mysql on your localhost read. Part 1 shows you how to setup up Apache on your Mac.
What green means: any lines that you need to replace in this tutorial will be in green.
Fix socket error:
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
Go to phpMyAdmin download page and choose the file in your language. I usually download phpMyAdmin-3.5.6-english.tar.gz
Unzip the file, rename it to phpMyAdmin, and move it into your Sites folder. You may need to create a Sites folder in your users directory.
Setup phpMyAdmin config:
1. Make the config folder
2. Change the permissions
chmod o+w ~/Sites/phpMyAdmin/config
Go to the new phpMyAdmin localhost URL in your browser and run the phpMyAdmin setup
Setup phpMyAdmin settings:
1. Open your browser and go to the url
2. Click “New server”
3. The new page will load and click on the “Authentication” Tab
4. Enter the Mysql root user and password (this was set in the previous mysql setup tutorial)
5. Click “Save” – This will take you back to the previous screen.
6. Scroll to the bottom of the page and click “Save” to finish
7. A new file called config.inc.php is now created in the /config directory that we created previously. Move this file from phpMyAdmin/config/ to phpMyAdmin/
8. Delete the /config folder
Go to your newly created phpMyAdmin:
1. Make sure your Mysql is running
sudo /usr/local/mysql/support-files/mysql.server start
2. Open your browser and go to the your phpMyAdmin url
3. Login using your mysql username and password
Congratulations! You have now installed phpMyAdmin to run on your Mac’s localhost. Pat on the back.