End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
tbl_name ADD (field_list)
Fixed problem with optimizer that could sometimes use incorrect keys.
GRANT/REVOKE ALL PRIVILEGES
Removed extra “
)” from the
Fixed problem when storing numbers in timestamps.
Fix problem with time zones that have half hour offsets.
Permit the syntax
UNIQUE INDEX in
mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.
New more secure mysqlaccess. Thanks to Steve Harvey for this.
READ LOCAL lock that doesn't lock the
table for concurrent inserts. (This is used by
LOCK TABLES ... READ no longer
permits concurrent inserts.
--skip-delay-key-write option to
Fixed security problem in the protocol regarding password checking.
_rowid can now be used as an alias for an
integer type unique indexed column.
Added back blocking of
--thread-safe-clients to make
things safe for old clients.