mac mysql 中文数据无法输入到数据库里_macbook堡垒机数据库中输入不了-CSDN博客

这里转载的该链接：https://mathiasbynens.be/notes/mysql-utf8mb4

⚠️：我现在的mysql版本是5.7

1、首先mysql中的utf8并不是utf－8，所以我搜到的解决该问题的一些文档，设置my.cnf的设置utf8方式都没有奏效

2、所以你要将数据库凡是为utf8格式的数据，更改为utf8mb4

首先你可以参考下面的语句调整数据库，然后简单测试一下可不可以插入：测试前请备份数据

Modify databases, tables, and columns

# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)

还有一个需要注意的点：格式转换后原来utf8（3个字节）就能表示的数据，现在要utf8mb4是用4个字节来表示的，在存储上要注意有所调整

3、如果上面你的测试结果ok，你可以尝试更改配置文件，这样就没必要在建数据后再调整字符集了

配置文件的修改方式，你可以参考某些中文文档，比如：http://www.xuebuyuan.com/2182964.html，只不过修改的内容要换成下面的内容：修改配置文件需要root权限

sudo su root

Make sure to set the client and server character set as well. I have the following in my MySQL configuration file (/etc/my.cnf):

[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

然后确认修改成功：

mac mysql 需要root权限： mysql -u root -p

You can easily confirm these settings work correctly:

mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name            | Value              |
+--------------------------+--------------------+
| character_set_client     | utf8mb4            |
| character_set_connection | utf8mb4            |
| character_set_database   | utf8mb4            |
| character_set_filesystem | binary             |
| character_set_results    | utf8mb4            |
| character_set_server     | utf8mb4            |
| character_set_system     | utf8               |
| collation_connection     | utf8mb4_unicode_ci |
| collation_database       | utf8mb4_unicode_ci |
| collation_server         | utf8mb4_unicode_ci |
+--------------------------+--------------------+
10 rows in set (0.00 sec)