What MySQL database admin app should I be using?

I use CocoaMySQL

I use the MySQL command-line tool. Learn it. Love it.

I was recently at a MySQL user group and like sferik said the MySQL command line tool seemed to be the weapon of choice. Im still very much a novice so I havent used it enough to vouch for it myself. But thats what im focusing on learning.

Use the command line. Ask us for help.

You wouldn’t use Dreamweaver, would you?

Haha okay. I get the message. I’ll be installing and playing with the command line tool then. Do you really find it more efficient than having a GUI interface? Or is it simply the flexibility you enjoy?

I might take you up on some of that help andrew im really interested in learning it

I’ve always used phpmyadmin just because that’s what I begun with, I don’t do much database admin and I don’t know much SQL for MySQL (or any SQL engine for that matter) but I’d love to learn how to use the command line for MySQL.

I agree with the CocoaMySQL recommendation. It doesn’t do everything but for day to day data inserts, updates and deletes it works very well. I still use the CLI for more administrative tasks.

phpMyAdmin isn’t bad, and puts a nice GUI on almost all functions.

Seconded: PHPMyAdmin

I agree with phpMyAdmin. the one thing i love about using the browser is that I can Command + F to find anything on the page.

Three months on:

To the phpMyAdmin fans, check out the recently released SQLBuddy. It’s faster and easier to navigate than MyAdmin. It doesn’t look like crap, either.

I am actually using the command line for pretty much all tasks now, and would like to thank sferik and andrew for a push in the right direction.

SQLBuddy is nice for dealing with heaps of data, though.

http://www.sqlbuddy.com