mysql数据库授权

mysql数据库授权所有人

grant all privileges on *.* to 'root'@'%' identified by 'password';

flush privileges;

 

GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@'%' IDENTIFIED BY 'zabbix';

flush privileges;

 

 

GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@'192.168.1.110' IDENTIFIED BY 'zabbix';

 

flush privileges;

 

 

GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';

 

 

 

flush privileges;