1. DB 생성
mysql> create dbname;
2. user 계정에 사용자 ID 추가
mysql> insert into user (Host, User, Password) values (’%’,’계정’,password(’암호’));
3. DB 계정과 DB연결
mysql> insert into db values(’%’,’DB명’,’계정’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’);
4. DB계정에 권한 주기
mysql> grant all privileges on dbname.* to username@’%’ identified by ‘password’;
5. DB 서버 갱신
mysql> flush privileges;
6. mysql 재가동
[root@linux /]# mysqladmin -u root [...]
my.cnf 편집
[client]
default-character-set=euckr
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set=euckr
init_connect=set collation_connection=euckr-korean_ci
init_connect=set names euckr
character-set-server=euckr
collation-server=euckr_korean_ci
character-set-client-handshake = FALSE
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
default-character-set=euckr
[mysql]
default-character-set=euckr
그리고 service mysqld restart