【Linux面試題】Mysql創(chuàng)建用戶和數(shù)據(jù)庫(kù)均為zabbix,同時(shí)授權(quán) 192.168.1.11 IP通過zabbix用戶和密碼zabbix123實(shí)現(xiàn)完全訪問?
【答案】:
shell> mysql
mysql> create database zabbix;
mysql> grant all on zabbix.* to 'zabbix'@'192.168.1.11' identified
by 'zabbix123';
mysql> flush privileges;