mysql5.7.21 utf8 encoding problem and solution in Mac environment

1. Goal: Change the value of character_set_server of mysql from latin1 to utf8

Temporary: SET character_set_server=utf8, one-time.

Permanent: You need to change the configuration file, see step 2.

2. There is no configuration file in the support-files of mysql 5.7.21.

Create a new my.cnf. You can create a text file and directly change the extension to cnf. It is best to open it with Xcode or subline. The content is as follows:

[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

3. Copy my.cnf to /private/etc/

cp /usr/local/mysql/support-files/my.cnf /private/etc/my.cnf

Note: /etc is actually a stand-in for /private/etc and can be copied to either.

4. Restart the mysql server and enter mysql

mysql>show variables like '%char%';

You can find that the encoding values ​​are all changed to utf8.

At this time, rebuild the database and table, and import the data to display Chinese normally.

Summarize

The above is the mysql5.7.21 utf8 encoding problem and solution in Mac environment introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!