nereuschen / blog

blog
44 stars 11 forks source link

mysql授权问题 #7

Open nereuschen opened 9 years ago

nereuschen commented 9 years ago

GRANT SELECT, INSERT, UPDATE, DELETE ON db_%.* TO 'test_rw'@'*'

GRANT CREATE ON test_db1.* TO 'test_rw'@'192.168.11.11'

导致该IP没有SELECT, INSERT, UPDATE, DELETE 权限

Server version: 5.6.16-64.2-log Percona Server (GPL)

http://www.hustdba.com/?p=215