Wednesday, September 14, 2011

How to connect MySQL when using MAMP

If running on the same computer you have MAMP installed on then the "Host" would be "localhost". If it's another computer on your same network, this is where you would enter its IP.

The default User name and password is:

Username: root
Password: root

Now if you were only able to connect through a socket, you need to add:

Socket: /applications/mamp/tmp/mysql/mysql.sock

Source: Link

I was also trying to find a free MySQL program since SQLYog was never ported to OS X. I found Sequel Pro which I like a lot so far!

Sequel Pro: Link