IT備忘録

$ sudo apt-get install mysql-server

文字コードをutf8に
$ gksudo gedit /etc/mysql/my.cnf
================================================
[client]の最下行に以下を追記
default-character-set = utf8

[mysqld]の Basic Settings の下に以下を追記
default-character-set = utf8
skip-character-set-client-handshake
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8

[mysql]の最下行に以下を追記
default-character-set = utf8
================================================

$ sudo service mysql restart