On January 17 2023, MySQL Server 8.0.32 was released. It is the latest release of our MySQL 8.0 General Availability Release.
The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes.
Let’s dive into some detail on these new features and changes
MySQL Enterprise
- On Windows, the MySQL Enterprise client-side Kerberos authentication plugin now supports GSSAPI through the MIT Kerberos library.
Optimizer
- Adding explain_format to make the default explain format configurable globally and per session. Possible options are DEFAULT, TRADITIONAL, JSON & TREE.
mysql> SET @@explain_format=TREE;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @@explain_format;
+------------------+
| @@explain_format |
+------------------+
| TREE |
+------------------+
1 row in set (0.00 sec)
mysql> EXPLAIN SELECT Name FROM country WHERE Code LIKE 'A%'\G
*************************** 1. row ***************************
EXPLAIN: -> Filter: (country.`Code` like 'A%') (cost=3.67 rows=17)
-> Index range scan on country using PRIMARY over ('A' <= Code <= 'A????????') (cost=3.67 rows=17)
Deprecations
- libmysqlclient: mysql_real_connect() CLIENT_NO_SCHEMA flag is deprecated.
- The legacy connection compression parameters are deprecated.
- Use of the dollar sign ($) as the first character of an unquoted identifier is now deprecated and a warning will be returned.
mysql> CREATE TABLE $table (col1 int); Query OK, 0 rows affected, 1 warning (0.03 sec) mysql> SHOW WARNINGS; +---------+------+-------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+-------------------------------------------------------------------------------------------------------------+ | Warning | 1681 | '$ as the first character of an unquoted identifier' is deprecated and will be removed in a future release. | +---------+------+-------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
More information
Find the full list of bugfixes and features on our release notes on https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-32.html
For more detail on security fixes as part of Oracle CPU Jan 2023, go to https://www.oracle.com/security-alerts/cpujan2023.html#AppendixMSQL
In conjunction with the MySQL Server 8.0.32 release, new 8.0 releases NDB Cluster, MySQL Connectors, MySQL Workbench, MySQL Shell, MySQL Router & MySQL Operator for Kubernetes happened, as well as maintenance release MySQL Server 5.7.41.
Changes in all these releases since the previous one can be viewed online on https://dev.mysql.com/doc/#current-release-notes
- Download our MySQL Community packages at https://dev.mysql.com/downloads/
- Use the Windows installer on http://dev.mysql.com/downloads/installer/
- MySQL Enterprise binaries are available on My Oracle Support: https://support.oracle.com (Choose the “Patches & Updates” tab, and then choose the “Product or Family (Advanced Search)” side tab in the “Patch Search” portlet.)
- or use Oracle Software Delivery Cloud on http://edelivery.oracle.com/ to download MySQL Enterprise binaries.
