创建库
create database zabbix character set utf8 collate utf8_bin;
创建用户
create user 'slave'@'IP' identified by 'passwd';
直接授权及建用户
- grant all privileges on busgps.* to 'busgps'@'%' identified by 'passwd' with grant option;
- grant all privileges on exam.* to 'exam'@'%' identified by 'passwd' with grant option;
- grant all privileges on entrycity.* to 'entrycity'@'%' identified by 'passwd' with grant option;
- flush privileges;
- show grants for 'busgps'@'%';
来源: http://www.bubuko.com/infodetail-3484782.html