Once you get everything up and running, and get the basics of MySQL down, here are some tools that can make database administration on the Mac a little simpler in terms of doing every day things, like creating databases, tables, searching, sorting and exporting:

Cocoa MySQL- http://versiontracker.com/dyn/moreinfo/macosx/17838

I use Cocoa MySQL every day. It crashes occasionally (it's still in the beta version), but I find it easy-to-use.

YourSQL - http://versiontracker.com/dyn/moreinfo/macosx/18018

Very similar interface to Cocoa MySQL

Navicat - http://versiontracker.com/dyn/moreinfo/macosx/13371

I haven't used this one as much, but it looks like it might be good.

Also, in the way of learning MySQL, I'd recommend Larry Ullman's _MySQL_ on Peach Pit press (ISBN 0-321-12731-5). It's an easy read and it will get you up and running quickly. I refer to this daily as well.

Good luck!

On Friday, August 22, 2003, at 09:12 AM, Rich Allen wrote:

iH

you may find this site helpful in getting MySQL running for the first time

http://www.entropy.ch/software/macosx/mysql/

also recommend that you spend some time learning how to be root, unix permissions, etc

- hcir

On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg wrote:

I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to.

As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases.

Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff.

Reply via email to