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;