macOS favorite osx mysql gui app?

[zimv20]

have done some poking around, and found:
- navicat
- sqlgrinder
- cocoamysql

and then there's always phpmyadmin. any others i should consider?

i'm just wondering what people here are using, which works best for you, which is up to date, etc.

i'm running mysql 5.x on my machine here, but it'd be nice to connect to some of my hosted databases, all mysql, running on linux/apache and mysql 4.1.19 and 4.1.21.

but mostly, i'd like a nice and easy-to-use tool for my desktop.

 

[jeremy.king]

Terminal - I learn more using mysqladmin and mysql in the command line.

Otherwise, I run phpMySQLAdmin on a web server.

One good cross platform tool that I have used that supports any JDBC datasource is DBVisualizer

 

[elppa]

I've only used CocoaMySQL from your list.


I would recomend it as I found it very simple and easy to get started with and more friendly than phpMyAdmin. It is not updated to frequently, but the 0.7 release was a big improvement speed wise over the 0.5 release.

Beware though — some hosting providers will only let you connect to the database locally, so it is not for every case.

 

[AlmostThere]

Well, it depends what you want the GUI for - when it come to admin tasks such as regular house cleaning, nothing beats the command line for building and running scripts. cron and the command line are your friend.

If you are a developer looking at quickly modelling ad hoc databases and maybe only later transferring your work on to larger / commercial systems, there are any number of tools. Sometimes the command line (or programmatically) other times, the default MySQL GUI toolkit meets most needs. I like PHPmyAdmin which has proven to be useful tool for remote web systems - easy to set up and with a really simple GUI that meets web backend needs ... but again it depends on those needs.

For developing SQL applications, I have found aqua data studio from aquafold to be a decent tool. It is $400 but is a versatile tool used with many different DB systems. This is very much about building building SPs, UDFs and other DB objects - the variety of supported databases for me being a big help too (should you need to look beyond mysql)

 

[pengu]

CocoaMySQL is good for inserting/exporting data, and building queries, but doesnt manage the db or the server.

Navicat will do most anything you can think of, and does it well. its not free though.

The Graphical tools from MySQL (query builder, administrator, migration toolkit and workbench) are generally quite good, once they're at a stable version.


i would suggest AGAINST phpMyAdmin unless you have tight security on it (such as limited IP's) due to its known security issues.


if you're in a production environment, i'd suggest Navicat, if not, and you dont have the money for it, a combination of MySQL GUI tools, CocoaMySQL and the terminal should work well..

 

[zimv20]

thanks for the responses.

though i'm normally very much a command-line kind of guy (been doing unix since '84), i'm not really much of an SQL guy, so i'd like a GUI tool for the db. i run a few LAMP websites, and i've been using phpmyadmin for those. those are all hosted elsewhere.

i'm going to be redoing my band's website, and i thought i've give ruby on rails a try, since my host just starting supporting it. but i'm going to develop the site on my mac first, then xfer it. for this effort, i'd like something GUI for mysql, and something a little nicer than phpmyadmin. since it's just on my local machine, i've really got no security concerns regarding the php thing.

i've already built and populated a mysql database for the current, live site, so my first task is to import that into my local mysql, then figure out how to get RoR running with that.

so this local db is just a toy, i won't be heavy into admin or tuning or anything like that.

i've just d/loaded cocoamysql and i'll see how i like that. thanks for the responses so far, and if anyone has anything additional to contribute, please chime in.