My main reason for using MySQL Workbench, at least for now, is for the really cool Data Modeling tools.
It a bit of a pain to MySQL Workbench up for MAMP, though. To set mySQL workbench up for MAMP, I found the following to work after scouring the internet and finding this simple to the point post at chrischarlton.us. I am sharing it again in this post to make finding help a bit easier for myself and others.
In the right side pane of the Front panel click “New Server Instance”.
The choose “localhost” and click Continue.
Even if the “Testing the Database Connection” tests all fail, click Continue.
The for Operating System & MySQL Package: Choose “Mac OS X”.
For the Testing Host Machine Settings: Even if the tests all fail, again, click Continue.
Check the “Change Parameters” checkbox and click Continue.
Update – the path to Configuration File: /Applications/MAMP/tmp/mysql/mysql.sock,
Note that both click “Check Path” then click “Check Name” – should pass.
here are the commands to start & stop MySQL respectively:
You may or may not need to check the elevated privileges checkbox.
Server Instance Name: MAMP@localhost (or whatever you want)
Im not sure why, exactly, but I had to do this a few times before I could get it to work. You may also need to restart your MAMP server. I hope this helps.