3.1.2.2.2 Upgrading MySQL 8.4 LTS to MySQL 9.x Innovation

MySQL 9.x Innovation introduces some new features and removes some deprecated features as compared to MySQL 8.4 LTS. Here are some important changes you should be aware of before upgrading your DB system from MySQL 8.4 LTS to MySQL 9.x Innovation:

• The mysql_native_password authentication plugin is removed in MySQL 9.0. Your user accounts cannot use the mysql_native_password authentication method.

  Note:

  Before upgrading, you must migrate all user accounts that use the mysql_native_password authentication method to the caching_sha2_password authentication method.

  Note:

  Inbound replication channels cannot authenticate to a source server as a user that is created with the mysql_native_password authentication method after the target server is upgraded to 9.x. You must recreate the replication user on the source using the caching_sha2_password authentication method. Also, any operation that involves the mysql_native_password authentication method on the source server (for example, creating or changing the password of a user account that uses the mysql_native_password authentication method) will break the replication.
• As of MySQL 9.2, the BINLOG keyword is restricted and can no longer be used unquoted as a label in a MySQL stored routine or stored function. You should update any affected applications accordingly, before upgrading to MySQL 9.2.

Related Topics

• What Is New in MySQL 9.0
• What Is New in MySQL 9.1
• What Is New in MySQL 9.2
• What Is New in MySQL 9.3

Parent topic: Server Upgrades