Hi, after minor upgrade 8.0.33-25.1 to 8.0.34-26.1 my error.log flooded with wanings:
2023-11-06T09:47:08.461867-00:00 845 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
I adeded to config file:
# nano /etc/mysql/mysql.conf.d/mysqld.cnf
set global log_error_suppression_list='MY-013360';
authentication-policy = 'caching_sha2_password'
After reboot, on server startup i still got error:
2023-11-07T08:59:30.230134-00:00 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
select @@default_authentication_plugin, @@authentication_policy;
+---------------------------------+-------------------------+
| @@default_authentication_plugin | @@authentication_policy |
+---------------------------------+-------------------------+
| mysql_native_password | caching_sha2_password |
+---------------------------------+-------------------------+
But i did not set this parameter and it is not in my mysqld.cnf (default for 8.0 should be caching_sha2_password
), so I set in mysqld.cnf :
default-authentication-plugin = 'caching_sha2_password'
Reboot once more. Now I have:
SQL > select @@default_authentication_plugin, @@authentication_policy;
+---------------------------------+-------------------------+
| @@default_authentication_plugin | @@authentication_policy |
+---------------------------------+-------------------------+
| caching_sha2_password | caching_sha2_password |
+---------------------------------+-------------------------+
But errors still flooding my error.log file 2-3 warnings every second when for testing I set back supressing:
set global log_error_suppression_list='';
2023-11-06T09:47:08.461867-00:00 845 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’`
Did this mean that I must recreate all my users accounts on Server?
ALTER USER 'dev-user'@'%' IDENTIFIED WITH caching_sha2_password BY 'xxxxxxxxxxxxxxxx';
There is a lot of users on a lot of clusters.
Is there any posibility to avoid this transfer from mysql_native_password
to caching_sha2_password
?