mysq创建用户并分配到某个数据库上

2014-11-24 17:06:54 · 作者: · 浏览: 0

mysq创建用户并分配到某个 数据库
Sql代码
create user 'kent'@'%' identified by 'kentpassword';
create user 'kent'@'localhost' identified by 'kentpassword';
grant all privileges on kentdb.* to 'kent'@'%' with grant option;
grant all privileges on kentdb.* to 'kent'@'localhost' with grant option;