Mysql 한글 설정

my.conf 파일 오픈 후 끝에 아래의 내용을 추가해줌

[client]

default-character-set=utf8

[mysqld]

default-character-set=utf8

collation-server = utf8_unicode_ci

init-connect='SET NAMES utf8'

character-set-server=utf8

[mysqldump]

default-character-set=utf8

[mysql]

default-character-set=utf8

또는 utf8 => ecukr로 변경하면 됨

설정 후 확인

mysql> status;

--------------

mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1

Connection id:          2

Current database:

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.0.77 Source distribution

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    euckr

Db     characterset:    euckr

Client characterset:    euckr

Conn.  characterset:    euckr

UNIX socket:            /var/lib/mysql/mysql.sock

Uptime:                 16 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 12  Flush tables: 1  Open tables: 6  Queries per second avg: 0.250