sql-info.de

MySQL Notes

1 | 2 | 3 | 4 | Index

MySQL 5 has come out of the alpha development phase with the release of the first public beta, 5.0.3.

The MySQL developer zone is carrying series of articles on the major new features, which include triggers, views and stored procedures.

Posted at 8:48 PM

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.

Posted at 8:27 AM

February 8, 2005

MySQL | MySQL and Windows Security

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:

Posted at 10:11 PM

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.

Posted at 2:04 PM

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
Posted at 10:23 PM

December 1, 2004

MySQL | TIMESTAMP DEFAULT NOW()

A common problem in MySQL is the comparatively simple act of defining a TIMESTAMP column which has as its default value the timestamp at the time the record is created. In most databases this is simply a case of appending DEFAULT NOW() to the timestamp column.

Beginning with version 4.1.2 MySQL now supports this, albeit as an overlay to the slightly eccentric TIMESTAMP functionality, making life just that little bit easier.

Posted at 8:40 PM

The most prominent new feature of MySQL 4.1 is the introduction of subqueries (also known as subselects), a very welcome addition which brings MySQL's feature set a little closer to that of other databases.

Posted at 10:10 PM

It's possible to modify the way in which MySQL interprets certain parts of SQL, useful when porting queries from other databases. For example, the option PIPES_AS_CONCAT will persuade it to accept || as a concatenation operator rather than as a synonym for OR (see also gotcha 1.12). In 4.1 this facility has been extended considerably.

Posted at 8:52 PM

1 | 2 | 3 | 4 | Index