主备> GRANT USAGE,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *.* TO 'zbxuser'@'%' IDENTIFIED BY 'p@ssw0rd'; #创建授权zbxuser权限并设置密码为'p@ssw0rd'单机> GRANT USAGE,PROCESS,SELECT,REPLICATION CLIENT ON *.* TO 'zbxuser'@'%' IDENTIFIED BY 'p@ssw0rd';> flush privileges;
mysql 8 及以上版本需要先创建用户再授权
create user 'zbxuser'@'%' identified by 'P@ssw0rd';GRANT USAGE,PROCESS,SELECT,REPLICATION CLIENT ON *.* TO 'zbxuser'@'%';flush privileges;