修改MySQL存储数据的默认编码

2018-3-10 created by AD1024
数据库
开发

修改方法

1配置文件

/etc/mysql目录下有一个my.conf,在文件末尾添加:

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

然后重启MySQL: sudo service mysql restart

2 已有数据库和数据表

对于每个数据库: ALTER DATABASE <DB> CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

对于每张表: ALTER TABLE <TB> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

最后重启数据库: sudo service mysql restart 即可