Another MySQL Question

Installing MySQL on a mac os x box

[aaronjf]

Ok, just to worn everyone in advance I wil lprobably be posting a lot of juvinile questions about MySQL here as they relate to OS X. I am breaking down and trieing to learn to build dynamic sites.

My question is has anyone tried to install MySQL on there OS X box? How hard was it? What is the best advice you can give for a dynamic newbee?

[bodine]

"My question is has anyone tried to install MySQL on there OS X box?

I just finished.

"How hard was it?"

Like most Linux/Unix installs I've done, it was not easy. I am very technical when it comes to the Mac, and I can follow instructions, but I found that the answers that the manual, and others, provided did not work on Mac OS X.

"What is the best advice you can give for a dynamic newbee?"

Besides "Run away, run as fast as you can"?

When you go to the main mysql site, follow the link to the Mac binary. Download and install it according to the instructions provided. Follow all of the instructions to the letter. And, when you figure out that it still does not work, do this:

(You may have to enter in the full path to each of the bin/script files, if you did not add the mysql directory to your path.)

To start the daemon, type "sudo safe_mysqld" at the shell prompt. Then enter the administrator's password (probably the same one you use when you install software).

Then, to start mysql, type "mysql --local-infile -u root -p DATABASENAME", and then enter the mysql password you set in the instructions. This is the part that took me forever to figure out. You will get Access Denied errors if you do not use the "-u root -p" options. You will get an error when you try to import data from a text file if you do not use the "--local-infile" option. There are very few places that have all of this info...I looked in several different places to find it. Now, it is on webmasterworld.com!

To shutdown the daemon (after exiting mysql), type "mysqladmin -uroot -p shutdown" and then enter the mysqladmin password.

That is about all I know other than to search on google.com for any errors you get. Be sure to include "mac" in the search, or you will get things related to other platforms.

Good luck!

[bodine]

For those who are interested, Apple posted a "how-to" about installing MySQL on Mac OS X:

[developer.apple.com...]

[transistor]

I did a lot of hard work to install PHP and MySQL under Mac OS X, but since I found this site I don't suffer anymore: [entropy.ch...]

[bodine]

Yes. That was the site that had the Mac binary that I talked about. But, the instructions were not complete...it got you to the point of the install, but then left you to figure out the rest. I appreciate what he wrote, but I wish he would have included a couple of more steps...

[transistor]

Bodine,
don't know what you mean.
I downloaded the package, double-clicked it and that's it, it is installed.
There is even a "startup item" that will start up MySQL automatically.
What happened to your installation?

[bodine]

The install went fine. But, I was getting the Access Denied errors I mentioned. And, the --local infile option problem. I was not the only one with those problems. It works fine. All I am saying is that the instructions are incomplete. Are you using 10.2? I am on 10.1.

[transistor]

I see...
I am still using 10.1.5, I am waiting until I can upgrade my B&W G3 to G4 and a decent video card to take advantage of Quartz Extreme.
The last time I installed MySQL was about two months ago, maybe three and I can't recall any problems (doesn't mean I didn't had problems!).

Anyway, I've copied and saved your post, just in case... hehehe! :)