On April 18 2023, MySQL Server 8.0.33 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.
New MySQL Enterprise Edition Data Masking Component
MySQL Enterprise Edition now provides data masking and de-identification capabilities based on components, rather than being based on a plugin library that was introduced in MySQL 8.0.13.
Next to now supporting multibyte character sets, the component implementation provides dedicated privileges to manage dictionaries and extends the list of specific types to include:
- Canada Social Insurance Number
- United Kingdom National Insurance Number
- International Bank Account Number
- Universally Unique Identifier (UUID)
An improved table-based dictionary registry replaces the file-based dictionary used by the plugin. For a summary of the differences between the component and plugin implementations, see Data-Masking Components Versus the Data-Masking Plugin. Existing plugin users should uninstall the server-side plugin and drop its loadable functions before installing the new MySQL Enterprise Data Masking and De-Identification components.
MySQL Enterprise Audit Log
MySQL Enterprise Audit previously only used tables in the mysql system database for persistent storage of filter and user account data. For enhanced flexibility, the new audit_log_database server system variable now permits specifying other databases in the global schema namespace at server startup. The mysql system database remains the default setting for table storage.
Components Usability Enhancements
INSTALL COMPONENT now includes the SET clause, which sets the values of component system variables while installing one or more components. The new clause reduces the inconvenience and limitations associated with the other ways of assigning variable values.
Security
- For platforms on which OpenSSL libraries are bundled, the linked OpenSSL library for MySQL Server has been updated to version 1.1.1t. Issues fixed in OpenSSL version 1.1.1t are described at https://www.openssl.org/news/cl111.txt
- Binary packages that include curl rather than linking to the system curl library have been upgraded to use curl 7.88.1.
- For more detail on other security fixes as part of Oracle CPU April 2023, go to https://www.oracle.com/security-alerts/cpuapr2023.html#AppendixMSQL
Terminology Changes
As part of ongoing work to change old terminology used in MySQL products, error messages relating to MySQL Replication are replaced with “source”, “replica”, and “MTA”, respectively. This includes all error messages listed in messages_to_clients.txt and messages_to_error_log.txt relating to replication.
Behavior Changes
The use of a generated column with DEFAULT( to specify the default value for a named column is not permitted and now emits an error message. (Bug #34463652, Bug #34369580)col_name)
Deprecations
User-defined collations (see Adding a Collation to a Character Set) are now deprecated.
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-33.html
In conjunction with the MySQL Server 8.0.33 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.42.
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.
