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

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

Sql代码

create user &＃39;kent&＃39;@&＃39;%&＃39; identified by &＃39;kentpassword&＃39;;

create user &＃39;kent&＃39;@&＃39;localhost&＃39; identified by &＃39;kentpassword&＃39;;

grant all privileges on kentdb.* to &＃39;kent&＃39;@&＃39;%&＃39; with grant option;

grant all privileges on kentdb.* to &＃39;kent&＃39;@&＃39;localhost&＃39; with grant option;