Questions about MySQL on OS X Server

[tomdkat]

I've got some questions about MySQL on OS X Server and hopefully someone here will know the answers.

1. MySQL 4.1.16 was installed on our server from a package downloaded from a non-MySQL website. The README file in the MySQL installation directory states to look at the COPYING file for the GPL (Free) license and the 'MySQLEULA.txt' file for commercial versions. The MySQL installation directory has ONLY the COPYING file. Is it safe to assume, then, that the FREE distribution of MySQL 4.1.16 was installed?
2. When I run the "mysql --version" command in a terminal window, the MySQL version reported is:
   
   mysql Ver 12.22 Distrib 4.0.24, for apple-darwin7.0 (powerpc)
   
   Yet when the server boots, I see a message about MySQL 4.1.16 starting. Does MySQL 4.1.16 identify itself as 4.0.24 on Mac OS X or something or do we have a "tweaked" MySQL installation?

Thanks!

Peace...

 

[eric2006]

This isn't really my area of expertise, but OS X Server comes with MySQL installed, and it looks like that's what's starting up. If you want to upgrade the built-in version, try the upgrade instructions linked:
http://developer.apple.com/internet/opensource/osdb.html

Edit: sorry, I misread your post, this probably isn't much help.

 

[tomdkat]

Thanks! Actually, that DOES help since I wasn't aware MySQL came with OS X. I'll check to see if I am picking up the wrong version with the "mysql --version" command (due to a path issue). That crossed my mind VERY early this morning/VERY late last night when I was driving home.

The link you posted mention MySQL is installed in /usr/local and the MySQL 4.1.16 installation I was looking at was in /usr/local but I'll double-check for another version, just in case.

Peace...

 

[Whitehill]

I run server 10.4.10, mysql lives in /usr/bin and says

Ver 14.7 Distrib 4.1.22​

 

[tomdkat]

Thanks! Actually, that DOES help since I wasn't aware MySQL came with OS X. I'll check to see if I am picking up the wrong version with the "mysql --version" command (due to a path issue). That crossed my mind VERY early this morning/VERY late last night when I was driving home.

Sure enough, was picking up MySQL 4.0.24 that came with OS X Server 10.3.

After 3 hours of agony getting MySQL 5.0.45 installed and configured to work with the app we're installing, I found MySQL on OS X 10.3 just won't work due to the application's requirements.

Oh well, at least I learned some stuff.

Thanks!

Peace...