Using mysql Workbench with a db set up through MAMP

I could not connect to the my sql database that I set up using MAMP with mysql Workbench.

Whilst MAMP is neat – I prefer mysql workbench for my sql coding.

So – how did I do this? Well, I found out that for the connection you need to use a socket/pipe connection to the mysql.sock at \Applications\MAMP\tmp\mysql\mysql.sock.

(Don’t forget to change the default user name from root.)