본문 바로가기

IT 기술/코드샘플

mysql 유저생성, 권한 쿼리

create user ''@'%' identified by '!';
create user ''@'%' identified by '#e';
create user ''@'%' identified by '$';


GRANT ALL PRIVILEGES ON *.* TO ''@'%' IDENTIFIED BY '!';
GRANT select, insert, update,delete ON *.* TO ''@'192.168.%' IDENTIFIED BY '#e';
GRANT select, insert, update,delete ON *.* TO ''@'192.168.%' IDENTIFIED BY '$';

flush privileges;