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