MySQL GUI for OS X


#1

G’day everyone,

I’ve got Rails up and running, but am having trouble finding a stable
MySQL client for OSX.

I was looking at the ‘Creating a weblog in 15 minutes’ screencast from
rubyonrails.org - what MySQL client is David using?

I’ve found the MySQL clients (Administrator / Query Browser) to be
highly unstable and rather pathetic under OSX.

If David is indeed running Admin/QB I’ll cry myself into a slab of VB.

Cheers,
Stephen


#2

Hi,

He’s using CocoaMySQL editor.

Janis


#3

Try PHPMyAdmin …
http://www.phpmyadmin.net/home_page/index.php

It’s a php web app so you’ll need a php enabled web server to run it.
Lot’s
of features.


#4

I don’t know which one he is using, but i really like the MySQL client
from Navicat, as this one is very stable and has some advanced features
other clients do not offer. the one, which i like the most is the option
to tunnel the connection through a ssh connection. this way, you do not
have to allow mysql connection from other servers than localhost, but
still be able to work on the servers database.
there is also a PostgreSQL version available.


#5

If you get CocoaMySQL, be aware that the main version you find out there
(0.5) does not support the newer password scheme of 4.1+. So if you’re
using a newer install of mySQL, grab the CocoaMySQL version here:

http://cocoamysql.sourceforge.net/beta/CocoaMySQL_0.7b2_v41.zip

There’s another beta there that doesn’t have the password hack.

Micah


#6

Jānis Jansons wrote:

Hi,

He’s using CocoaMySQL editor.

Janis

Thanks Janis!

I’ve downloaded it and it still seems pretty stable!


#7

I have used Navicat but didn’t like it. CocoaMySQL is very good, you
can get it from sourceforge.net. I also use the Query Browser
available for free in the download section of MySQL.com pretty sweet
since it has the help built right in the client, although it is a
working progress; but you should check it out.

Cheers,
Farhan


#8

There’s also YourSQL which is pretty good, and seems too have been
updated more recently.

http://yoursql.ludit.it/


#9

Micah B. wrote:

If you get CocoaMySQL, be aware that the main version you find out there
(0.5) does not support the newer password scheme of 4.1+. So if you’re
using a newer install of mySQL, grab the CocoaMySQL version here:

http://cocoamysql.sourceforge.net/beta/CocoaMySQL_0.7b2_v41.zip

There’s another beta there that doesn’t have the password hack.

Micah

Thanks Micah.

I’ll download the latest beta and check it out :slight_smile:

Navicat looks pretty good, although if I spend any money on software I
might have to convert to PostgreSQL because its my preferred platform. I
noticed they have a pgsql client which looks cool…

Thanks for your replies everyone…!


#10

Navicat is the only tool I will use - Mac or PC. A DB connection tool is
something you use every day, break down and pay for a good one.
Cocoamysql
and yoursql are garbage to me.


#11

I’ve used all three, and paid for Navicat. I honestly prefer
CocoaMysql.

Jamie


#12

subimage interactive wrote:

Navicat is the only tool I will use - Mac or PC. A DB connection tool is
something you use every day, break down and pay for a good one.
Cocoamysql and yoursql are garbage to me.
Am I the only one who’s happy at the command line? :slight_smile:


#13

In article removed_email_address@domain.invalid,
Alex Y. removed_email_address@domain.invalid wrote:

subimage interactive wrote:

Navicat is the only tool I will use - Mac or PC. A DB connection tool is
something you use every day, break down and pay for a good one.
Cocoamysql and yoursql are garbage to me.
Am I the only one who’s happy at the command line? :slight_smile:

No you’re not. Though after seeing the migrations screencast I’m
switching to do everything with them instead.

jpb


Joe B. removed_email_address@domain.invalid

Have GNU, will travel.


#14

Have you read
http://particletree.com/notebook/the-different-faces-of-mysql/ yet?
I don’t know which ones run on Mac, but I think the article might be
usefull…

Johan Van M.
http://www.onrails.be


#15

On Sunday, February 26, 2006, at 8:18 AM, Vince P. wrote:

G’day everyone,
If David is indeed running Admin/QB I’ll cry myself into a slab of VB.

Cheers,
Stephen


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

There is also MySQL Workbench although it is still in alpha, AFAIK:
http://www.openwin.org/mike/video/WorkbenchAlphaDemo/WorkbenchAlphaDemo.html

At the same time, I really liked the way of building database gradually
using migrations (I think Chad F. demonstrated it very well in the
Rails Recipes book).

Best Regards, Roustem.


#16

I’ve got Rails up and running, but am having trouble finding a stable
MySQL client for OSX.

The application you speak of is CocoaMySQL and it freakin’ rocks.
Go here and get it:

http://cocoamysql.sourceforge.net/