当前位置:首页 > IT技术 > 数据库 > 正文

zabbix系列:mysql数据授权zabbix用户
2021-09-11 10:30:05


#MySQL监控用户


shell# su mysql
shell# mysql -uroot -p'123456' 
mysql> GRANT USAGE,SELECT,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *.*  TO 'zabbixMySQL'@'localhost' IDENTIFIED BY 'zabbixMySQL';  
mysql> flush privileges;
mysql> select user,host from mysql.user;

 

#删除用户

drop user 'zabbixMySQL'@'localhost';

 

 


本文摘自 :https://blog.51cto.com/u

开通会员,享受整站包年服务立即开通 >