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.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
July 02, 2007 2:38pm
Subscribe [2]#1 / Jul 02, 2007 2:38pm
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.
#2 / Jul 02, 2007 3:21pm
I posted the answer over on the thread I started on ExpressionEngine forums.
#3 / Jul 03, 2007 10:31am
Try this
server: localhost:3306
user: username
pass: password
Port is optional and only work for, I think for Postgre
#4 / Jul 03, 2007 11:41am
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)
#5 / Jul 03, 2007 3:03pm
@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?
#6 / Jul 03, 2007 3:48pm
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 😉
#7 / Jul 03, 2007 5:05pm
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?