GRANT SELECT,INSERT,UPDATE,DELETE ON aaa.* TO 'zhangzy'@'10.1.%.%' IDENTIFIED BY '1111';
GRANT SELECT,INSERT,UPDATE,DELETE ON aaa.* TO 'zhangzy'@'127.0.0.%' IDENTIFIED BY '1111';
flush privileges
GRANT SELECT,INSERT,UPDATE,DELETE ON aaa.* TO 'zhangzy'@'10.1.%.%' IDENTIFIED BY '1111';
GRANT SELECT,INSERT,UPDATE,DELETE ON aaa.* TO 'zhangzy'@'127.0.0.%' IDENTIFIED BY '1111';
flush privileges