유저생성
create user 'ms'@'%' identified by '1234'
% ==> 모든 도메일
**
create user '유저명'@'도메일' identified by '비밀번호''
권한부여
grant all priviliges on test.* to 'ms'@'%' ;
**
grant all priviliges on [db명].* to 'user name'@'domain';
반응형
유저생성
create user 'ms'@'%' identified by '1234'
% ==> 모든 도메일
**
create user '유저명'@'도메일' identified by '비밀번호''
권한부여
grant all priviliges on test.* to 'ms'@'%' ;
**
grant all priviliges on [db명].* to 'user name'@'domain';