MySQL 계정 생성, 권한 부여

CREATE USER 'DB'@'IP' IDENTIFIED BY 'PASSWORD';

 

1) 특정 권한

GRANT SELECT, INSERT, UPDATE, DELETE ON DB .* TO 'DB'@'IP' ;

 

2) 모든 권한

GRANT ALL PRIVILEGES ON DB .* TO 'DB'@'IP' ;

 

FLUSH PRIVILEGES;