PDA

View Full Version : MySql Manager for OS X




MrSugar
Jan 14, 2006, 07:09 AM
Hey there,

I have been using Cocoa Mysql for a while now but I am finding that it runs somewhat slow and doesn't really do all the DB managment I need.

I am looking for a nice GUI MySql manager for OS X. So far the only thing I have found is Navicat, which works pretty well but is pretty expensive, even for edu :(.

I would be curious to know what other people out there use for their MySql management, perhaps you guys have some low cost, or freeware apps that work well.

Thanks.



BornAgainMac
Jan 14, 2006, 10:51 AM
Here is a free one (http://www.mysql.com/products/tools/administrator/index.html)

MrSugar
Jan 14, 2006, 02:45 PM
Here is a free one (http://www.mysql.com/products/tools/administrator/index.html)

Thanks for the help but I have tried this one. Unfortunately it doesn't work to well. It consistently puts out "Incorrect Syntax" errors when trying to make even the most basic tables in MySQL.

Any other ideas?

radiantm3
Jan 14, 2006, 02:54 PM
http://cocoamysql.sourceforge.net/

It's pretty good. (and open source)

MrSugar
Jan 14, 2006, 03:18 PM
Thanks for the help, I don't know if you read my first post but I have tried Cocoa MySql before but it seems to have trouble connecting to remote mysql db's.

bigandy
Jan 14, 2006, 04:59 PM
i just use phpMyAdmin (www.phpmyadmin.net)

easy to install and configure, and has NEVER failed for me, or any of my customers, on any of my servers, or development machines.

MrSugar
Jan 14, 2006, 05:01 PM
i just use phpMyAdmin (www.phpmyadmin.net)

easy to install and configure, and has NEVER failed for me, or any of my customers, on any of my servers, or development machines.

Yeah, I have used phpmyadmin, but I am looking for something that can connect via client side. Unfortunately my school doesn't have phpmyadmin set up on their server :/. And I would use my own but I need coldfusion capability for this particular project.

superbovine
Jan 15, 2006, 01:03 AM
Yeah, I have used phpmyadmin, but I am looking for something that can connect via client side. Unfortunately my school doesn't have phpmyadmin set up on their server :/. And I would use my own but I need coldfusion capability for this particular project.

how big is the project? can't you just suck it up and do it by hand.

angelneo
Jan 15, 2006, 01:21 AM
Not much of a choice left for you. The best one I seen out there is navicat. Blah, just use the plain old command line. :p

belvdr
Jan 16, 2006, 09:50 AM
If you learn the command-line way of doing things, you'll be better off to handle anything coming down the road that a GUI may not help you with.

There were some things in Toad that would not work correctly in our 10g environment, then they patched it. Of course, we could work around it in SQL*Plus because we knew how to do it the old-fashioned way.

superbovine
Jan 16, 2006, 05:25 PM
If you learn the command-line way of doing things, you'll be better off to handle anything coming down the road that a GUI may not help you with.

There were some things in Toad that would not work correctly in our 10g environment, then they patched it. Of course, we could work around it in SQL*Plus because we knew how to do it the old-fashioned way.

Ironically in the new Oracle Education courses for 10g DBA old fashion way isn't even pushed that hard. They really push Enterprise Manager. My guess is so they can make more money cause more people will get through the courses.

belvdr
Jan 16, 2006, 08:12 PM
Ironically in the new Oracle Education courses for 10g DBA old fashion way isn't even pushed that hard. They really push Enterprise Manager. My guess is so they can make more money cause more people will get through the courses.

That's a very bad idea in my opinion. A DBA who doesn't understand entirely what is happening in the background can be very dangerous.

Another plus to the push of EM is that it is a separately licensed product, which equates to more money for Oracle.

ryan
Jan 16, 2006, 11:31 PM
YourSQL (http://yoursql.ludit.it/)

MrSugar
Jan 17, 2006, 03:29 PM
YourSQL (http://yoursql.ludit.it/)

Thanks Ryan, I will give this a try!

MrSugar
Jan 20, 2006, 08:28 AM
YourSQL (http://yoursql.ludit.it/)

I wanted to say thank you for this. It is perfect, exactly what I needed. Thank you so much Ryan!