1. 유저생성 :
1.1. 로컬access only :
grant all privileges on *.* to 'mysqluserid'@'localhost' identified by 'userpassword' with grant option;
1.2. remote access add :
grant all privileges on *.* to 'mysqluserid'@'%' identified by 'userpassword' with grant option;
2. DB 생성 :
2.1. euc-kr charset 으로 db create :
create database db_name default character set euckr collate euckr_korean_ci;
2.2. utf8 charset 으로 db create :
create database db_name default character set utf8 collate utf8_general_ci;