사용자 추가
[code]
create user ‘user1’@’localhost’ identified by ‘password’;
[/code]
사용자 삭제
[code]
drop user ‘user1’@’localhost’;
[/code]
권한부여
[code]
grant all privileges on 디비명.* to ‘user1’@’localhost’;
[/code]
권한제거
[code]
revoke all on 디비명.* from ‘user1’@’localhost’;
[/code]
권한보기
[code]
show grants for ‘user1’@’localhost’;
[/code]
