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)
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.
