思路：一.创建一个用户，设置帐号密码
二.分别赋予该用户多个库的权限.
|
1
2
3
4
5
6
|
mysql> use mysql;
Database changed
mysql> create user
'developer'
@
'192.168.0.66'
identified by
'EacxsdfdJqd'
;
mysql> grant
select
on muu.* to
'developer'
@192.168.0.66;
mysql> grant
select
on bu.* to
'developer'
@192.168.0.66;
mysql> flush privileges;
|
记得flush privileges.
本文转自 yawei555 51CTO博客，原文链接：http://blog.51cto.com/huwei555/1770664，如需转载请自行联系原作者
