[UBUNTU] MySQL 설치 및 UTF8 설정

출처 - http://iccc.skku.ac.kr/zbxe/tip_tech_service/71356

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

sudo apt-get install mysql-server mysql-client

$sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.orig


my.cnf 파일 편집

    [client]
    default-character-set=utf8

    [mysqld]
    character-set-client-handshake=FALSE
    init_connect="SET collation_connection = utf8_general_ci"
    init_connect="SET NAMES utf8"
    default-character-set=utf8
    character-set-server=utf8
    collation-server=utf8_general_ci

    [mysqldump]
    default-character-set=utf8

    [mysql]
    default-character-set=utf8

mysql을 재시작

    $sudo /etc/init.d/mysql restart

변경 여부 확인

    $mysql -u id -p
    mysql> status