一偿警、檢查默認(rèn)字符集
mysql> show variables like '%char%';
+--------------------------+-----------------------------------------------------------+
| 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/local/mysql-5.7.19-macos10.12-x86_64/share/charsets/ |
+--------------------------+-----------------------------------------------------------+
8 rows in set (0.00 sec)
character_set_database和character_set_server依然是latin1的字符集歌懒，也就是說(shuō)mysql后續(xù)創(chuàng)建的表都是latin1字符集的锰瘸，不是utf8暑椰，會(huì)造成一些麻煩贡耽。所以有必要修改my.cnf，在修改my.cnf之前一定要關(guān)閉mysql進(jìn)程泉孩，不然會(huì)遇到mysql的sock不能連接的問題。
二并淋、關(guān)閉 mysqld 后臺(tái)進(jìn)程
三寓搬、修改 mysql 配置文件
sudo vi /etc/my.cnf
添加如下內(nèi)容
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
然后重啟 mysql
四、檢查結(jié)果
mysql> show variables like '%char%';
+--------------------------+-----------------------------------------------------------+
| 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/local/mysql-5.7.19-macos10.12-x86_64/share/charsets/ |
+--------------------------+-----------------------------------------------------------+
8 rows in set (0.01 sec)
