[MYSQL] DB 생성 및 계정 설정

1. DB 생성

CREATE DATABASE sqldb default character set utf8;

2.계정 및 권한 생성

grant all privileges on sqldb.* to sqluser@'localhost' identified by 'passwd' with grant option;

grant all privileges on sqldb.* to sqluser@'%' identified by 'passwd' with grant option;

flush privileges;

3.권한 삭제

권한 삭제는 
REVOKE all on *.* from sqluser@host;

4.계정 삭제

drop user sqluser@host;

ALTEER DATABASE [DB] DEFAULT CHARACTER SET=UTF8;

ALTEER TABLE [TABLE] DEFAULT CHARACTER SET=UTF8;