Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Navicat Premium 10.1.1 and MAMP PRO 2.1.4.

MAMP PRO is set to use the port 3306 for MySQL. When I try to create a new MySQL connection in Navicat, I set the hostname as localhost, port as 3306, username and password as root. But, when testing connection, it shows "Can't connect to MySQL server on '' (61)".

Does someone know what can be the problem?


  1. MAMP PRO is already started;
  2. I also tried to use instead of localhost as the hostname.
share|improve this question
up vote 3 down vote accepted

Uncheck "Allow local access only" in Server > MySQL.

share|improve this answer

OK. I just got it.

I had to change in the Connection properties of the connection I created, the following:

In the Advanced tab:

  1. Check the Use socket file option
  2. Set this path for the field above: /Applications/MAMP/tmp/mysql/mysql.sock

Note that the path to use is available in /Applications/MAMP/bin/ (given that I'm using MySQL).

share|improve this answer

Allowing local access resolved it for me.

share|improve this answer
Can you add a bit more detail to improve this answer? – Dave M Nov 28 '13 at 15:18

protected by bwDraco May 21 '15 at 20:53

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.