Shulou(Shulou.com)06/01 Report--

After installing Mysql 5.7 on Mac, some character sets default to latin1 instead of utf8. To avoid garbled characters, this article introduces setting all character sets to utf8.

View current character set encoding show variables like '%char %';

We'll see that these character sets are latin1

Modify the character set to utf8 Close Mysql service Create a new my.cnf configuration file, execute the following command, if it already exists, it will open sudo vim /etc/my.cnf Press i key to enter edit mode and add the following configuration, then press esc key to exit edit mode and press shift+zz to save [client]default-character-set = utf8 [mysql]default-character-set = utf8 [mysqld]character-set-server=utf8 Start Mysql service, check code, success

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.