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.
