1. DB 추가
mysql> insert into db values('localhost','testdb','testuser','y','y','y','y','y','y','n','y','y','y','y','y','y','y','y','n','n','y','y');

2. USER 추가
mysql> insert into user values('localhost', 'testuser', password('userpass'),'Y','Y','Y','Y','Y',' Y ',' Y',' Y ',' Y',' Y ',' Y',' Y ',' Y',' Y',' Y',' Y',' Y ',' Y',' Y',' Y ',' Y',' Y',' Y',' Y ',' Y',' Y',' Y',' Y','','',' ','',' 0 ','0 ',' 0 ','0');

3. 변경사항 적용
mysql> flush privileges;


1.계정추가
INSERT INTO user (Host, User, Password) VALUES ('localhost', '계정아이디', password('비밀번호'));

FLUSH privileges;

2.디비생성 및 권한부여
CREATE DATABASE 데이터베이스명;
GRANT ALL privileges ON 데이터베이스명.* TO 계정아이디@localhost IDENTIFIED BY '비밀번호';