526互联

5.mysql8.0以上版本，ProxySQL 监控/连接账户，要以 mysql_native_password 形式创建，否则会连接拒绝

发布时间 2023-11-24 15:04:36作者: zhangdapangzi

CREATE USER 'monitor'@'%' IDENTIFIED BY '123456';
grant all privileges on *.* to 'monitor'@'%' with grant option;
flush privileges;

 

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

ALTER USER 'monitor'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'monitor'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456;

ALTER USER 'rpl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

flush privileges;
select user,host,plugin from user;