Re: Setting up MySQL on Mac OS X
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up MySQL on Mac OS X
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.
Re: Setting up MySQL on Mac OS X
Bob Goldberg [EMAIL PROTECTED] 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. What exactly error did you get? 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. Database 'mysql' is created by mysql_install_db script. 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. Any hints? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up MySQL on Mac OS X
G'day Bob 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. There is an alternative installation you might want to consider. Go to www.serverlogistics.com and download complete MySQL. Whilst there, also get Complete Apache2 and Complete PHP:) All these packages are 'double click' installers and the Apache and MySQL come with preference panes for turning them on and off and basic configuration. They also install in non-apple locations so they aren't affected by system updates. Very clear documentation as well. I can't recommend them highly enough. I agree about CocoaMySQL - I too use it every day and it is very capable. It can't do permissions from the GUI but if you're only doing minor development/learning this won't affect you. A small tip for a neat little word processor called (formerly) Hydra which is native OSX, has PHP and HTML syntax highlighting and 'static' line numbering for debugging. It can also be used collaboratively with Rendevous. http://hydra.globalse.org/ You might also want to look at JaneBuilder www.seejanecode.com for a neat app that writes pretty good PHP/MySQL with very little trouble. cheers kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]