Can anyone tell me how to connect CocoaMySQL to the locally installed version of MySQL that comes with Mamp? It should be as simple as:

server: localhost
user: username
pass: password
port: 3306 (optional)

But that doesn’t seem to work.

I posted the answer over on the thread I started on ExpressionEngine forums.

Try this

server: localhost:3306
user: username
pass: password

Port is optional and only work for, I think for Postgre

I tried cocoamysql and mamp and i’ll be quite honest i thought it was pretty rubbish. (i like mamp though)

If you want a mysql gui for mac there is only one. Navicat. I have got it for windows and downloaded the trial for mac. It simply blows any other mysql gui out the water.

It is so reliable, easy to use and just great. I love it. (if you couldn’t tell)

@maurice
Thanks, but I found the answer and linked to it above. It had to do with the socket field.

@audiopleb
I’ve used AquaFold’s Aqua Data Studio back when they had a free version and it let me connect basically any DB that I wanted and had nice interface. The only problem was the $399 price tag if I wanted to continue to use it. That’s the best one I’ve tried on the mac platform thus far.

Based on your comment I’ve just downloaded the Navicat demo and am giving it a shot. What, in your opinion, makes Navicat so great? Is it really worth $129 to connect to one type of database?

It works. End of story!

I use it so much on windows i might as well marry it.

I really am talking from experience, i have used every mysql client under the sun for windows and they all pale in comparison.

I have tried about 10,000,000 different clients for mac now and i have found fault with each and every one. Navicat just works.

The visual query builder is only for select queries though, don’t expect it to do any other type in that way. You have to write your queries mostly.

I cant think of anything else to say really, as you have a trial you should be able to come to your own conclusions about it. I would wager you buy it though

It looks good but I can’t say that it’s $129 good. I’ll try it for the trial period (30 days) and see.

Anyone else have any insight into Navicat?