D.5.25 Changes in release 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 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 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().

User Comments

Add your own comment.