MySQL Notes
MySQL 5 has come out of the alpha development phase with the release of the first public beta, 5.0.3.
- Download page: http://dev.mysql.com/downloads/mysql/5.0.html
The MySQL developer zone is carrying series of articles on the major new features, which include triggers, views and stored procedures.
MySQL AB has released new versions of its flagship products. MySQL 4.1.10 provides several small fixes, including "predefined accounts without passwords for remote users" in the Windows distribtion (presumably in connection with the recent Windows security issue).
Also MaxDB 7.6 Beta has been made available in preparation for the production version release scheduled for the second quarter of 2005.
Following the recent bot attacks against poorly secured MySQL installations on Windows (not a MySQL vulnerability), MySQL AB has published an article detailing how to best secure a MySQL server running on Microsoft platforms:
A worm is on the loose attacking MySQL installations on computers running Windows. This does not appear to be a MySQL exploit; rather one which takes advantage of weak security to use MySQL functions to insert malicious code into the system.
The mysqldump utility doesn't provide any inbuilt
facilities for compressing output. This can be a problem if the
disk space available is smaller than the dump's final size.
On Linux and UNIX systems the way round this is to compress
mysqldump's output on the fly, e.g. using the bzip2
utility:
mysqldump -uroot -pPASSWORD --opt --all-databases | bzip2 -c > mysql-full-dump.bz2