connection to database ‘zabbix’ failed: [2059] Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

zabbix-server启动报错，解决如下

//进入mysql执行如下sql
ALTER USER 'zabbix'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

select host,user,plugin from mysql.user;