MySQL, the industry-leading open-source SQL database, is an accessible, easy-to-use relational database management system (RDBMS). As an alternative to Oracle and SQL server, MySQL offers features and capabilities that were once only available to users of expensive proprietary systems.
What's New
Version 5.1.60:
Functionality Added or Changed
Upgrading from an Advanced GPL RPM package to an Advanced RPM package did not work. Now on Linux it is possible to use rpm -U to replace any installed MySQL product by any other of the same release family. It is not necessary to remove the old produce with rpm -e first. (Bug #11886309)
MEMORY table creation time is now available in the CREATE_TIME column of the INFORMATION_SCHEMA.TABLES table and the Create_time column of SHOW TABLE STATUS output. (Bug #51655, Bug #11759349)
Bugs Fixed
InnoDB Storage Engine: This fix improves the performance of instrumentation code for InnoDB buffer pool operations. (Bug #12950803, Bug #62294)
InnoDB Storage Engine: Data from BLOB columns could be lost if the server crashed at a precise moment when other columns were being updated in an InnoDB table. (Bug #12704861)
InnoDB Storage Engine: Lookups using secondary indexes could give incorrect matches under a specific set of conditions. The conditions involve an index defined on a column prefix, for a BLOB or other long column stored outside the index page, with a table using the Barracuda file format. (Bug #12601439)
InnoDB Storage Engine: This fix corrects cases where the MySQL server could hang or abort with a long semaphore wait message. (This is a different issue than when these symptoms occurred during a CHECK TABLE statement.) (Bug #11766591, Bug #59733)
Replication: Issuing the following statements, in the order shown, could cause a deadlock between the user thread and I/O thread: START SLAVE; STOP SLAVE SQL_THREAD; START SLAVE; (Bug #11878104) See also Bug #44312, Bug #11752963, Bug #38715, Bug #38716.
Internal conversion of zero to binary and back could yield a result with incorrect precision. (Bug #12911710)
Valgrind warnings generated by filesort operations were fixed. (Bug #12856915)
Several improvements were made to the libedit library bundled with MySQL distributions, and that is available for all platforms that MySQL supports except Windows.
Navigation keys did not work for UTF-8 input.
Word navigation and delete operations did not work for UTF-8 input with Cyrillic characters.
Nonlatin characters were corrupted in overwrite mode for UTF-8 input.
Long queries caused the statement history file to become corrupted.
Upgrading from an Advanced GPL RPM package to an Advanced RPM package did not work. Now on Linux it is possible to use rpm -U to replace any installed MySQL product by any other of the same release family. It is not necessary to remove the old produce with rpm -e first. (Bug more...
Server software has different version numbering from regular software. With servers, stability and continuity are often more important than features, therefore, server software has multiple parallel branches that are maintained side-by-side, and one only upgrades to a higher numbered version when absolutely necessary.
So, with MySQL, 5.5.x is the latest feature updated branch, but 5.1.x is not "old", it's merely a separate branch, which, having been in use for a longer period of time, is probably slightly more stable.
In any event, MU should include links to the latest version of 5.1.x and 5.5.x. Both are valid and current branches of MySQL. With server software, it's not about either/or but both/and.
Version 5.0.51 has just been released, however, it doesn't work out of the box on my Mac with OS X 10.5.2.
I've filed a bug report that contains a workaround that circumvents the permissions issues. However, this is okay for a development Mac like min, you MUST NOT do it on a production system.
Thanks, it works! I recently found a "fix" to get the preference pane working in Leopard, but it didn't work for me. This "official" fix works great though.
thanks so much for this link. I stumbled on this form about a year after my original post-- and have been booting via command line for too long.
For those of you who need more info... this pref. pane works for those who did the custom work-around in the previous posts on this topic. Worth trying at any rate... you can't harm your computer.
It's a permissions issue. This will solve it "brute force", I'm too lazy to figure out exactly which permissions misbehave for my development only system.
Unfortunately, many developers seem to believe that MySQL is a 'free' product, when it isn't. Its licensing scheme is quite restrictive for professional production.
Although newer versions are more stable, have more of the *basic, required* features that make a database engine a 'true' database system (such as foreign key support, and transaction rollback), the truth is that there are other systems out there - such as the excellent and much under-used PostreSQL - which, in my experience, have a less restrictive license, are more advanced, supporting more standard features, and still just as cross-platform.
What happened to the package installer? I installed the x86 version two weeks ago, and it had a packaged installer. I had to reinstall today (reinstalled the OS), and all of the installers on MySQL's site are command line only. I'm certain I got the Mac x86 packaged installer from MySQL's site. What happened to it?
The MySQL package for Mac OS X makes the basic installation procedure a snap (as opposed to the old process that required building and installing it from the command line). The System Preferences pane is handy, too - although it could do with providing access to a few more options, too.
You still have to do a bit of manual setup, but it's getting easier and easier.
Be sure to get the free MySQL Administrator application (also from MySQL AB) for a Mac OS X graphical front end to administration of MySQL.
[Version 5.0.20]
-1
Anonymousreviewed on 01 Oct 2005
No problem with opening .dmg
Take care to download the right version for your OSX 10.x
Easy install.
I manage my databases with phpMyAdmin.
For Mathematica afficionados : don't forget that Mathematica can connect (but you need to update to mysql-connector-java-3.1.10-bin.jar) to mysql databases, manages queries and handles datas. A delight.
[Version 5.0.13]
There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.
Please login or create a new MacUpdate Member account to use this feature
Watch Lists are available to MacUpdate Desktop Members Upgrade Now
Download and auto-install
using MacUpdate Desktop. Save
time moving folders and cleaning-up.
MySQL, the industry-leading open-source SQL database, is an accessible, easy-to-use relational database management system (RDBMS). As an alternative to Oracle and SQL server, MySQL offers features and capabilities that were once only available to users of expensive proprietary systems.
+80
Yet MacUpdate is linking to 5.1.57.
What gives?
+544
So, with MySQL, 5.5.x is the latest feature updated branch, but 5.1.x is not "old", it's merely a separate branch, which, having been in use for a longer period of time, is probably slightly more stable.
In any event, MU should include links to the latest version of 5.1.x and 5.5.x. Both are valid and current branches of MySQL. With server software, it's not about either/or but both/and.
+76
-45
+31
I've filed a bug report that contains a workaround that circumvents the permissions issues. However, this is okay for a development Mac like min, you MUST NOT do it on a production system.
http://bugs.mysql.com/34814
+31
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip
+139
-1
For those of you who need more info... this pref. pane works for those who did the custom work-around in the previous posts on this topic. Worth trying at any rate... you can't harm your computer.
-1
sudo mkdir /var/mysql/
sudo ln-s /tmp/mysql.sock /var/mysql/mysql.sock
Note that MySQL PreferencePane is not working correctly.
PHP 5.2.4 is already installed in leopard (but not activated).
+31
sudo chmod -R a=rwX mysql-5*
Here's more:
http://bugs.mysql.com/bug.php?id=28854
-1
http://www.nabble.com/MySQL-Install-on-OS-X-Leoperd-t4699997.html
The key is to start the server first and then run VincentJ's code...
note... there should be a space before the"-s"
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
+1
+34
teksestro reviewed on 17 Jun 2007
Although newer versions are more stable, have more of the *basic, required* features that make a database engine a 'true' database system (such as foreign key support, and transaction rollback), the truth is that there are other systems out there - such as the excellent and much under-used PostreSQL - which, in my experience, have a less restrictive license, are more advanced, supporting more standard features, and still just as cross-platform.
+57
+449
+37
+187
-1
GrantNeufeld reviewed on 21 Apr 2006
You still have to do a bit of manual setup, but it's getting easier and easier.
Be sure to get the free MySQL Administrator application (also from MySQL AB) for a Mac OS X graphical front end to administration of MySQL.
-1
Anonymous reviewed on 01 Oct 2005
Take care to download the right version for your OSX 10.x
Easy install.
I manage my databases with phpMyAdmin.
For Mathematica afficionados : don't forget that Mathematica can connect (but you need to update to mysql-connector-java-3.1.10-bin.jar) to mysql databases, manages queries and handles datas. A delight.