Alterações na distribuição 3.22.11
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 inuser@host
format. Formerly it returned onlyuser
. - 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 ofSIGQUIT
with shutdown to work better on FreeBSD. - Added option
\G
(print vertically) toMariaDB
. SELECT HIGH_PRIORITY ...
killedmysqld
.IS NULL
on aAUTO_INCREMENT
column in aLEFT JOIN
didn't work as expected.- New function
MAKE_SET()
.