MySQL 服务日志出现如下警告:
2024-05-27T08:43:12.412102Z 9 [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'
my.cnf
配置文件,新增如下配置[mysqld]
log_error_suppression_list='MY-013360'
my.cnf
配置文件,新增如下配置[mysqld]
default_authentication_plugin = caching_sha2_password
ALTER USER '用户名'@'主机名' IDENTIFIED WITH caching_sha2_password BY '密码';
示例:
ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY '123456';