2月 242015
 

/etc/my.cnfを以下のないように変更して、mysqldを起動しなおす。

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
collation-server = utf8_general_ci
default-character-set = utf8
skip-character-set-client-handshake
 
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
collation-server = utf8_general_ci
default-character-set = utf8
skip-character-set-client-handshake
 
[client]
default-character-set = utf8

既にcharacter_set_databaseが、utf8以外になっている場合は、
以下のコマンドで変更が可能です。

mysql> alter database disney character set utf8;

Sorry, the comment form is closed at this time.