MAMP Works. MAMP Pro Does Not Allow Navicat Connection

[heavymark]

Hello,

With MAMP everything works perfectly.

With MAMP Pro, Apache and mySQL starts up fine as well as access to mySQL through phpMyAdmin.

However when I try to connect a local WordPress Install with MAMP Pro or when I try to connect to the database with Navicat Premium I get this error:

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

For settings I am using:

localhost
user: root
pass: root (yes, this is correct)
port: 3306 (yes matches MAMP Pro, tried setting both to 8889 as well with no luck)
Setting Save Path: /Users/Chris/Library/Application Support/Navicat Premium/Heavy Mark Local

The same settings in NaviCat with MAMP Pro turned off and MAMP turned on, work perfectly.

I have tried unstalling both, and installing just MAMP Pro and other variations.

I am on Snow Leopard, and still in the Trial Period of MAMP Pro, as its very pricey, and want to make sure it works first as currently it does not.

Any ideas?

[Lakestone]

I'm having the exact same issue here, and I use Navicat as well, can it be the problem? I used Navicat with XAMPP before and it worked like a charm. Can it be access restrictions? Maybe we have to set the user rights for Navicat?

I don't know, I'm no server expert, I hope someone from the MAMP team can help us out here.

[mrkevans]

Same here. Just got mamp pro installed and can't use navicat. Exact same issue

[mrkevans]

I got it to work. In navicat under connection properties -> advanced
you have to check use socket file for local connections

and then set the socket path = /Applications/MAMP/tmp/mysql/mysql.sock

that should be the right path. You can find it in the startmysql.sh script in the bin dir of the mamp install