grant all PRIVILEGES on *.* to cheyooh_user@'111.111.111.101' identified by 'cheyooh_user';
grant all PRIVILEGES on cheyooh_user.* to cheyooh_user@'111.111.111.100' identified by 'cheyooh_user';
GRANT Select ON *.* TO reader@'218.17.202.202' IDENTIFIED BY "password112";
grant all PRIVILEGES on *.* to kevin@'218.17.202.202' IDENTIFIED BY '88888888';
grant select,reload,replication slave,replication client on *.* to nagios@'127.0.0.1' identified by "123456";
flush privileges;
grant all PRIVILEGES on cheyoh_ad.* to jerry@'%' identified by '66666666';
转载于:https://blog.51cto.com/devin223/1714672