OK so this took me more than a minute to figure out, so I wanted to bump this answer for future google searches:
If you’re using MAMP and want to check out any databases created via applications run in MAMP, do this:
Host: localhost
User: root
Password: root
Database: [blank]
Socket: /Applications/MAMP/tmp/mysql/mysql.sock
Port: 8889
Getting the socket right was the tricky thing for me. Hope this helps.
