centos 7.9安装zabbix proxy 代理
安装mysql教程8.0.30
https://www.cnblogs.com/huzhimin/p/18630995
root
MyNew@123
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Zabbix@2025'； 改更root的密码
show databases; 查看所有的库
DROP DATABASE IF EXISTS zabbix_proxy; 删除库
SELECT User,Host FROM mysql.user; 查看所有用户
DROP USER 'zabbix'@'localhost'; 删除用户
create database zabbix_proxy character set utf8mb4 collate utf8mb4_bin;
create user zabbix@localhost identified by 'Zabbix@123';
grant all privileges on zabbix_proxy.* to zabbix@localhost;
GRANT SUPER ON *.* TO 'zabbix'@'localhost';
flush privileges;
cat /usr/share/zabbix-sql-scripts/mysql/proxy.sql | mysql --default-character-set=utf8mb4 -uzabbix -pZabbix@123 --database=zabbix_proxy
更改认证插件
mysql -u root -p
SELECT user, host, plugin FROM mysql.user WHERE user = 'zabbix' AND host = 'localhost'; 查看用户'zabbix'@'localhost'的认证插件
ALTER USER 'zabbix'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Zabbix123'; 强制修改用户的认证插件为mysql_native_password
FLUSH PRIVILEGES; 刷新权限
SELECT user, host, plugin FROM mysql.user WHERE user = 'zabbix' AND host = 'localhost'; 查看用户'zabbix'@'localhost'的认证插件