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.
Step 1
Fix socket error:
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
Step 2
Download phpMyAdmin:
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.
/Users/username/Sites/phpMyAdmin
Step 3
Setup phpMyAdmin config:
1. Make the config folder
mkdir ~/Sites/phpMyAdmin/config
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
Step 4
Setup phpMyAdmin settings:
1. Open your browser and go to the url
localhost/~username/phpMyAdmin/setup/
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
Step 5
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
localhost/~username/phpMyAdmin/
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.
Part 1: How to install Apache and PHP on a Mac with OSX 10.8 + (MAMP Part 1)
Part 2: How to setup MySQL on a Mac with OSX 10.8 + (MAMP Part 2)
Part 4: How to enable and setup php.ini on a Mac with OSX 10.8 + (MAMP Part 4)
Part 5: How to host multiple sites on your Mac (MAMP Part 5)
53 replies on “How to setup phpMyAdmin on a Mac with OSX 10.8 + (MAMP Part 3)”
Hi Jonathan,
I tried to install phpMyAdmin. but there is a problem.
Im unable to execute this command ‘chmod o+w ~/Sites/phpMyAdmin/config’.
after run this command,config folder is still empty.
Hey, this is indeed the simplest, clearest guide to setting up MAMP I have found. Much appreciation for your work.
I worked through Parts 1, 2 and 3 without problems, until I get to Part 3,
Step 5 and cannot log into http://localhost/~richard/phpMyAdmin/
-Though I see “Welcome to phpMyAdmin” page and enter my username/password, I only receive ‘waiting for localhost…’ browser message; the login screen doesn’t change; no error message.
-Cookies are enabled.
-I’ve checked my /Sites/phpMyAdmin/config.inc.php file for username (‘root’ without quote marks) and password; I’m using them in the login screen (though I did try ‘richard’ as username, got same response).
-I’ve restarted Apache & and stopped/started Mysql (in that order).
-I’ve changed the config.inc.php as suggested:
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
to
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
-I checked Apache for errors with sudo apachectl -t and received the following:
“httpd: Could not reliably determine the server’s fully qualified domain name, using Richard-Prices-Computer-4.local for ServerName
Syntax OK.” I don’t know if this means anything is wrong or not.
-I’ve tried everything except resetting the mysql password (your first reply to a question). i’m afraid I’m command line ignorant; I couldn’t get those commands to work in Terminal.
-I’m at wits end. Any help?
Thanks,
Richard
Argh. Okay. Figured it out. Disregard my post of yesterday.
I had left my “User for config auth” in the Authentication tab of the “Add a new server” screen set to ‘root’ (failed to change it to my username). Now all is well to this point!
Amazing what a few hours break will do, that plus a 2nd walk thru the steps.
Richard
Hi Richard,
Sorry for the late response. It is amazing what a couple hours away will do. I’m constantly surprised by that myself. Thanks for taking the time to comment. Have a great day.
Hi Jonathan,
Thanks very much for the great tutorial.
I have a problem
Not able to login to phpMyAdmin
I have already changed
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
to
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
as per your previous posts. But still it doesn’t work
Can you help me to solve this. I have an interview coming up within 3 days, so I trying to setup and learn php and mysql. Please help me. This is going to be a life saver for me
Thanks Jonathan
Biju
Hi Biju,
Will send you a private email tonight, hopefully will be able to help you resolve this.
Ho Jonathan, I am also facing the same issue.
Just want to echo others. These MAMP install guides are among the most useful documents on the subject. I thought I’d have to get all proprietary with Zend (boo demise of community edition) or use my yahoo host to get started. Found your docs and I was up an running in minutes while learning a bit along the way. I’ll certainly be looking to see what other wisdom you have made available. Thanks.
Glad these helped you out Steve
Thanks so much! Greetings from Nigeria, Africa. This is the most helpful tutorial on Mac. Please keep up the good work.
Hi Okechi, thanks for the kind words
Hey, I’ve got a big one. It doesn’t matter how many times i set up the password, it won’t tell me anything but wrong password. I reset it, and it still asks for the new one.
Help me out, please.
Hope you were able to resolve this. It is possible that your may need to edit your /Sites/phpMyAdmin/config.inc.php file
Update the following line from:
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
to:
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
Let me know if this worked for you
It did. Thanks a lot!
THANKS!!!!
Hi Jason, no problem
I did all these steps and when I login in to myphpadmin nothing happens…..no errors or anything.
please disregard my last question about username. I’ve verified in the config file what my username and password are. However, I’m still not seeing anything happen after I enter the my username and login.
Hi Vick. You will need to make sure the phpMyAdmin configuration file is setup correctly. Take a look at /Sites/phpMyAdmin/config.inc.php to verify. Hope that helps
Great tutorial. The best by far. One problem for me: In the last step, nothing happens after I input the username and password. What is the MySQL username? is it the same as my username on my macbook? Where were we asked to create a MySQL username?
Thank you so much for your help! This was great!!!!!!
Oh good, glad it was useful
A whole day I spent pulling my hair to get this to work. THANK YOU!!!!!!!!!!!
Until I found your tutorials I meant to say. Once I did it was easy peasy even for a Terminal newbie. Thnx again!
Thanks Freddy, You probably found it doesn’t take long to get your bearings with Terminal. Best of luck with your setup
I’m just getting the index of the folder when I go to http://localhost/~(my username)/phpMyAdmin/setup/.
Did everything exactly to your guide. What’s wrong?
Hi Tyler,
It’s hard to diagnose without seeing your setup. That is the right address so it should be working.
phpMyAdmin has their own documentation that might be of help to you
go to http://localhost/~username/phpMyAdmin/Documentation.html
You were simply great.
A clean, simple and perfect tutorial!!!
Thank you a lot. Without your help I would have never figured out how to set up this. Great work.
Great tutorial. Clear, concise and accurate. Thank you.
Wheewww… 3 hours and 5 different web-tuts later, you have finally got my headache solved. Thank you so much Jonathan for this tutorial, you saved me!
No on to learning how to create and or import my clients database.
Thanks , I was struggling with config path.
Thanks a lot. Saved me lots of time and headache. Keep up your good work
No problem Hal. Glad it worked out for you.
Hey Jonathan,
Thanks for the tutorial.
Im a bit stuck though at one step. First I didn’t manage to “fix the socket error” at the beginning, nothing happened when I typed it at the terminal. Then I followed the other steps, however, when I try to go to “http://localhost/~laurasantana/phpMyAdmin/setup/” it says I dont have permission:
Forbidden
You don’t have permission to access /~laurasantana/phpMyAdmin/setup/ on this server.
Even though I followed the step on changing permissions. can you help me out a bit?
Hi Laura. It’s possible you may need to change the permissions of the phpMyAdmin folder. This will give Apache permission to access these files. Run the following in your Terminal.
cd /Users/username/Sites/
sudo chown -R :_www phpMyAdmin
sudo chmod -R g+w phpMyAdmin
I had the same error but still doesn’t work
Hi Manuel, try restarting Apache? Also does the /~username/phpinfo.php file work for you?
Hi Manuel, Also try running the following command to see if there are any errors in the configuration files.
sudo apachectl -t
Let me know if any errors show up.
MacBook-Pro:Sites USERNAME$ sudo apachectl -t
httpd: Syntax error on line 131 of /private/etc/apache2/httpd.conf: Could not open configuration file /usr/conf/extra/httpd-phpmyadmin.conf: No such file or directory
The /conf/ directory doesn’t exist (I checked) What do I do?
Hi Kinect3000,
Can you share line 131 of your configuration file. It’s a syntax error which likely means a file path is wrong. Easy to fix.
Include conf/extra/httpd-phpmyadmin.conf
LoadModule proxy_http_module libexec/apache2/mod_proxy_http.so
Fixed it, just remove ” Include conf/extra/httpd-phpmyadmin.conf “
Hello Jonathan,
Your guide has been very useful this far, but I have a problem. When I try to access http://localhost/username/phpMyAdmin/Setup , I get a 404 error that says that it wasn’t found on the server.
Why is this? Please help me.
Thanks a lot 🙂
Hi Nicole,
Were you able to resolve this problem? Did you use the ~ in front of your username?
Such as http://localhost/~username/phpMyAdmin/Setup
Having the same issue here. Tried it with ~ in the front of the username but none? Any ideas?
#1045 Cannot log in to the MySQL server
still getting what can i doo
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg[‘Servers’][$i][‘verbose’] = ”;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ‘1111’;
/* End of servers configuration */
$cfg[‘blowfish_secret’] = ’51a1c71db0f361.43788765′;
$cfg[‘DefaultLang’] = ‘en’;
$cfg[‘ServerDefault’] = 1;
$cfg[‘UploadDir’] = ”;
$cfg[‘SaveDir’] = ”;
?>
I just wanted to mention that logging in to phpMyAdmin gave me the following error:
#2002 Cannot log in to the MySQL server
This can easily be fixed by changing a line in the config.inc file:
Line 14 before:
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
Line 14 after:
$cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’;
Thanks for the great tutorial!
Hi Christian, thanks for sharing
Hello Jonathan,
First of all, thank you for posting this guide. Helped me a lot. I have a problem in logging in. Looking through the web, I found a ton of useless advice, followed most of them and I’m still having the same problem.
I get this – #1045 Cannot log in to the MySQL server – can you advice what could I possibly be doing wrong in my setup? I really will appreciate it if you can respond to this.
Thank you.
MySQL doesn’t allow blank passwords by default. You can change that setting. Is your mysql password set correctly?
Yes it is already set.
The error seems like a password error.
Try resetting your password.
mysql -uroot
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘your password here’);
flush privileges;
exit
mysql -u root -p xxxx