Note that this blog post has been archived. Information may be out of date or incorrect.

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 '' (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


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