Important: You must run the
mysql_fix_privilege_tables
script when
you upgrade to this version! This is needed because of the
new GRANT
system. If you don't do this,
you will get Access denied
when you try
to use ALTER TABLE
, CREATE
INDEX
, or DROP INDEX
.
GRANT
to allow/deny users table and
column access.
Changed USER()
to return a value in
user@host
format. Formerly it returned
only user
.
Changed the syntax for how to set
PASSWORD
for another user.
New command FLUSH STATUS
that resets most
status variables to zero.
New status variables: aborted_threads
,
aborted_connects
.
New option variable: connection_timeout
.
Added support for Thai sorting (by Pruet Boonma
<pruet@ds90.intanon.nectec.or.th>
).
Slovak and Japanese error messages.
Configuration and portability fixes.
Added option SET SQL_WARNINGS=1
to get a
warning count also for simple (single-row) inserts.
MySQL now uses SIGTERM
instead of
SIGQUIT
with shutdown to work better on
FreeBSD.
Added option \G
(print vertically) to
mysql
.
SELECT HIGH_PRIORITY ...
killed
mysqld
.
IS NULL
on a
AUTO_INCREMENT
column in a LEFT
JOIN
didn't work as expected.
New function MAKE_SET()
.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.