프로그램/database

mysql 유저 생성 및 db 생성

mulderu 2009. 1. 6. 07:43
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;