Using Navicat with a MAMP MySQL database on Mac OS X


When trying to connect to a MAMP MySQL database with Navicat, I initially got the following unhelpful error message

Connection Failed
Can't connect to MySQL server on '127.0.0.1' (61)

even though all settings (Hostname, Port, User, Password) seemed to be correct. I am not quite sure why this happens, but it can be solved by pointing Navicat to the MAMP MySQL server socket, by setting

/Applications/MAMP/tmp/mysql/mysql.sock

as the Socket File Path in the “Advanced”-Tab, and you’re done.