當(dāng)前位置:首頁 > IT技術(shù) > 數(shù)據(jù)庫 > 正文

zabbix系列:mysql數(shù)據(jù)授權(quán)zabbix用戶
2021-09-11 10:30:05


#MySQL監(jiān)控用戶


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

開通會(huì)員,享受整站包年服務(wù)立即開通 >