Question

怎么把utf8mb4编码的数据库导入mysql里面。

Answer 1

在Mysql数据库配置文件(my.ini)中加入如下设置
[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数据库，确认设置生效
mysql> show VARIABLES like '%char%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /home/app/mysql-5.5.33/share/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set