MySQL UTF-8 언어 설정 방법

MySQL UTF-8 언어 설정 방법

[command]# cat /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

 

init_connect='set names utf8'
character-set-server=utf8
default-collation=utf8_unicode_ci
skip-character-set-client-handshake
character-set-filesystem=utf8
default-character-set=utf8

 

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

[mysql]
default-character-set=utf8

 

[client]
default-character-set=utf8

 

[mysqldump]
default-character-set=utf8

 

[command]# # /etc/init.d/mysqld restart
Stopping MySQL:  [  OK  ]
Starting MySQL:  [  OK  ]

 

[command]# # mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 

mysql> show global variables like '%char%';
+--------------------------+----------------------------+
| Variable_name                   | Value                                          |
+--------------------------+----------------------------+
| character_set_client           | utf8                                            | 
| character_set_connection  | utf8                                            | 
| character_set_database     | utf8                                            | 
| character_set_filesystem    | utf8                                            | 
| character_set_results         | utf8                                            | 
| character_set_server          | utf8                                            | 
| character_set_system        | utf8                                             | 
| character_sets_dir             | /usr/share/mysql/charsets/     | 
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

 

mysql> quit

Bye

 

[command]#