在/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
对于每个数据库:
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
即可