.RHEL 10 introduces MySQL 8.4
RHEL 10 is distributed with MySQL 8.4. Notable changes over the previously available version 8.0 include:
* The deprecated `mysql_native_password` authentication plug-in is no longer enabled by default.
* When upgrading to MySQL 8.4, user accounts or roles that have the `BINLOG_ADMIN` privilege are automatically granted the `TRANSACTION_GTID_TAG` privilege.
* When you install MySQL 8.4, the `mysql_upgrade_history` file is created or updated in the server's data directory. The file is in JSON format and includes information about the version installed, date and time of installation, and whether the release was part of a Long-Term Support (LTS series) or an Innovation series.
* The use of the `%` and `_` characters as wildcards in database grants has been deprecated, and the wildcard functionality will be removed in a future MySQL release. These characters will be treated as literals. They are already treated as literals when the `partial_revokes` server system variable is set to `ON`.
* The treatment of the `%` character by the server as a synonym for localhost when checking privileges has been deprecated.
* The deprecated `--ssl` and `--admin-ssl` server options and `have_ssl` and `have_openssl` server system variables have been removed. Use the `--tls-version` and `--admin-tls-version` server system variables instead.
* The deprecated `default_authentication_plugin` system variable has been removed. Use the `authentication_policy` server system variable instead.
* The deprecated `SET_USER_ID` privilege has been removed. Instead, you can use the `SET_ANY_DEFINER` privilege for definer object creation and the `ALLOW_NONEXISTENT_DEFINER` privileges for orphan object protection.
* The deprecated `mysql_upgrade` utility has been removed.
For more information, see the link:
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html[upstream MySQL documentation].