Well, here as well we missed an update, sorry about this I hope to keep you more up to date to stuff like this the coming period. The bug is still there so you still need to recompile !

This release includes a number of security-relevant fixes:

• CREATE TABLE LIKE did not require any privileges on the source table and was not isolated from alteration by other connections. (Bugs #25578 and #23667)
• It is no longer possible to use a view to gain update privileges for tables in other databases. (Bug#27878)
• It is no longer possible for a user to gain privileges by calling a stored routine that was declared using SQL SECURITY INVOKER. (Bug#27337)
• The DROP privilege requirement for RENAME TABLE is now correctly enforced. (Bug#27515)
• Malformed password packets in the connection protocol can no longer cause the server to crash. (Bug#28984)

One bug fix resulted in an incompatible change:

• The use of an ORDER BY or DISTINCT clause with a query containing a call to the GROUP_CONCAT() function caused results from previous queries to be redisplayed in the current result. The fix for this includes replacing a BLOB value used internally for sorting with a VARCHAR; this may lead to truncation when the result of a query that uses GROUP_CONCAT() is longer than the limit for VARCHAR, which is a new restriction in MySQL 5.0.45. (Bugs #23856, #28273)

Read about all the changes here.

Yes it’s finally there, the version that includes shared libraries in the binary distribution package which would mean we never have to recompile MySQL ourselves. I’ve downloaded the package and installed it on my test server. The installation went without a problem as usual, but trying to compile PHP brought a new issue, some linking issue with zlib libraries.

/usr/bin/ld: warning multiple definitions of symbol _inflateInit_
/usr/local/mysql/lib/libmysqlclient.dylib(inflate.o) definition of _inflateInit_
/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc/i686-apple-darwin8/4.0.1/../../../libz.dylib(inflate.o) definition of _inflateInit_
etc...

I guess we still need to recompile. I hope it is not due to some left over trial I did earlier, could someone confirm my findings ?

There is a light at the end of the tunnel, after complaining and blogging about the issue for some time it looks like it is going to be solved in the next release of MySQL. I received some updates on the bug report via email and it is released in version 5.0.40 Enterprise version, see the release notes. Now we only need to wait for the Community release….

MySQL has released version 5.0.37 of the Community Server. This is a binary and source-only release. You can read all about the new/changed functionality and bugfixes in the release notes. You can download the latest source version from the MySQL.com site.

You can download the binary install and do the source compile/install to get a functional 5.0.37 version running with all the goodies and defaults from the binary install. You still need to do the recompile to get the shared libraries. The bug still isn’t fixed, please add your vote to the bug-report to get this silly issue solved !

MySQL has released a new version of the Community Server 5.0.33. This is a source-only release, which means that MySQL.com will not provide binary builds. You can read all about the new/changed functionality and bugfixes in the release notes. You can download the latest source version from the MySQL.com site.

Because of the new Community release policy, there will be source only releases between the full (binary) releases. I was unable to find out what the reason for it was or when a version qualifies for a binary release.

You can download the binary install of a previous version and do the source compile/install to get a functional 5.0.33 version running with all the goodies and defaults from the binary install (like a startupitem and preference pane).

Not everybody is a Terminal wizard and some people really love to use their mouse to do their stuff. It’s good to know for them that MySQL has a package of tools that allows you just to that. The pachage includes the following tools to administer, create and maintain your database:

MySQL Administrator
http://www.mysql.com/products/tools/administrator/

MySQL Query Browser
http://www.mysql.com/products/tools/query-browser/

MySQL Migration Toolkit
http://www.mysql.com/products/tools/migration-toolkit/

MySQL Workbench
http://forge.mysql.com/wiki/MySQL_Workbench