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;