INSERT INTO user VALUES ('192.168.0.%', 'myuser', PASSWORD('mysuer'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO db VALUES ('192.168.0.%', 'MyDB', 'myuser', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N');FLUSH PRIVILEGES;MyDB 为你的数据库名,注意大小写
INSERT INTO db VALUES ('192.168.0.%', 'MyDB', 'myuser', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N');FLUSH PRIVILEGES;MyDB 为你的数据库名,注意大小写
ON what
TO user IDENTIFIED BY "password"
WITH GRANT OPTION privileges 有ALL,SELECT,INSERT,UPDATE等
what指明授权的某个数据库,表,甚至字段
user,用户,由用户名和主机名组成
password,密码
WITH GRANT OPTION,可选,指明该用户可以把自身拥有的权限赋予其他用户比如:
GRANT ALL ON mytestdb.* TO [email protected].% IDENTIFIED BY "youpassword"
or
GRANT ALL ON *.* TO [email protected].% IDENTIFIED BY 'password'
or
GRANT ALL ON *.* TO user@% IDENTIFIED BY 'password'