proxysql2.0以后支持caching_sha2_password

需要设置全局变量
vi proxysql.cnf

admin_variables=
{
    admin-hash_passwords=false
}
目前配置文件修改不生效，原因未知

命令行设置

update global_variables set variable_value='false' where variable_name='admin-hash_passwords';
#存盘
load admin variables to runtime; save admin variables to disk;
#载入用户
load mysql users to runtime; save mysql users to disk;

查看
select * from global_variables where variable_name like '%hash_passwords%';