GRANT ALL PRIVILEGES ON some_database.* TO monty@localhost IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON some_database.* TO monty@'%' IDENTIFIED BY 'some_pass';
grant all privileges on db.* to xx@localhost indentified by 'pass' 只是将某个数据库授权给某个用户 可是我想将某个用户只能绑定在一个数据库上,看不到其他任何的数据库 用上面的语句还是可以show databases和show tables
IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON some_database.* TO monty@'%'
IDENTIFIED BY 'some_pass';
只是将某个数据库授权给某个用户
可是我想将某个用户只能绑定在一个数据库上,看不到其他任何的数据库
用上面的语句还是可以show databases和show tables