I am currently using MySQL 8.0.33 and am planning to upgrade to version 8.0.35.
In my configuration file (my.cnf) I have set:
default_authentication_plugin=mysql_native_password.
According to the MySQL 8.0.35 release notes found at
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-35.html, it is mentioned that "mysql_native_password now replaces caching_sha2_password as the default authentication method when the server does not support pluggable authentication."
I typically add users using the following command:
CREATE USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
Given this information, I am concerned about whether there will be any issues logging in with these accounts after upgrading to MySQL 8.0.35.