MySQL GUI for OS X

Rails
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 …

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 [email protected],
Alex Y. [email protected] 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. [email protected]

Have GNU, will travel.

14

Have you read
Particletree » 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
[email protected]
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/