1.背景
linux中mysql8默認(rèn)的字符集是latin1，在插入中文時(shí)會(huì)報(bào)錯(cuò)，所以一般在配置好mysql時(shí)需要修改字符集為utf8【又叫utfmb3,一般開(kāi)發(fā)夠用，一個(gè)字符用3個(gè)字節(jié)表示】或者utfmb4【一個(gè)字符用4個(gè)字節(jié)表示，如果存儲(chǔ)emoji表情，必須用utfmb4】
1366 - Incorrect string value: xE4 xBA xBA(xE7 x94 x9F’ for column ‘book name’ at row 1
查看當(dāng)前數(shù)據(jù)庫(kù)的字符集
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
發(fā)現(xiàn)默認(rèn)是latin1
2. 修改字符串為utf8
- 修改
/etc/my.cnf配置文件 - 重啟
mysql - 重新查看字符集
2.1 修改/etc/my.cnf配置文件
[root@VM-4-6-centos /]# cd etc
[root@VM-4-6-centos etc]# vim my.cnf
進(jìn)入到編輯頁(yè)面
保存并退出
2.2 重啟mysql
systemctl restart mysqld.service
2.3 重新查看字符集文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-624539.html
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
大功告成?。?！文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-624539.html
到了這里，關(guān)于mysql進(jìn)階-修改linux服務(wù)器中MySQL的字符集的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
