MySQL Server 8.2.0, 8.0.35 and 5.7.44 are now available for download.  These are the latest General Availability (GA) releases as of October 24, 2023.

MySQL Server 8.2.0 GA, an innovation release includes:

MySQL Server 8.0.35 GA release includes:

MySQL Server 5.7.44 GA release includes:

  • Bug and security fixes
    Note: 5.7.44 is the final release of 5.7 (8 years since GA). It will now be covered under Oracle Lifetime Sustaining Support.

Both 8.0.35 and 8.2.0 releases come with full production support.

What’s new in MySQL Server 8.2.0

Security

  • New! FIDO2 WebauthN authentication
    • WebAuthn is the main component of FIDO2
    • WebAuthn enables MySQL to support biometrics, mobile devices, FIDO security keys, etc.
    • Provides far greater security versus passwords.
    • Enables Multi-Factor Authentication
  • Firewall
    • Option to provide custom database schema for Firewall Tables
    • Enables finer grained control of Firewall data replication – simple to include or exclude from the replication stream.
  • The mysql_native_password server plugin is now optional
    • By uninstalling its no longer available
    • Re-install ONLY if it’s needed for migration
    • Alter SHA1 passworded users to use caching_sha2
    • Note: SHA1 hashes are vulnerable and usage is deprecated

                 For example: to convert a user from mysql_native_password to caching_sha2_password

ALTER USER 'jeffrey'@'localhost'
IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD
PASSWORD EXPIRE
FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2;

Performance

  • Hash table optimization
    • Improves performance of EXCEPT and INTERSECT operations

Dev

  • EXPLAIN improvements
    • Store EXPLAIN FORMAT=JSON output in user variable
    • For SELECT/INSERT/REPLACE/UPDATE/DELETE
    • Example: EXPLAIN FORMAT=JSON INTO @var select_stmt;
    • This improves ease of use by providing a simple way for a DBA to access from within the server versus client.
       
  • Support query attributes for prepared statements
     
  • MySQL Router Read/Write Splitting
    • Simplifies scaling application SQL traffic over a cluster of servers.
    • Provides application transparent read/write connectivity for either
      • SECONDARY in an InnoDB Cluster
      • PRIMARY/SECONARY of REPLICA cluster in an InnoDB ReplicaSet

We’ve also released the 8.2 versions of MySQL Clients, Tools, and Connectors.

  • Provide production support MySQL Server 8.0, 8.1, 8.2, and 5.7
  • Include support for new server features
  • Backward compatibility to prior releases

When upgrading clients, tools, and connectors, use the latest release regardless of the server versions in use.

As always, thank you for using MySQL.