Thursday, August 30, 2012

MySql Permission for external client


GRANT SELECT ON `mysql`.`proc` TO root@192.168.10.209;
GRANT SELECT ON `mysql`.`proc` TO root@192.168.10.208;
GRANT SELECT ON `mysql`.`proc` TO root@192.168.10.207;

Grant All on ABC.* to root@192.168.10.209;
Grant All on ABC.* to root@192.168.10.208;
Grant All on ABC.* to root@192.168.10.207;

grant CREATE ROUTINE on ABC.* to root@192.168.10.209;
grant CREATE ROUTINE on ABC.* to root@192.168.10.208;
grant CREATE ROUTINE on ABC.* to root@192.168.10.207;

No comments:

Post a Comment