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

bitsCN.com

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;  

bitsCN.com