【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;