How to modify the default character set encoding in MySQL

How to modify the default character set encoding in MySQL

Today, I encountered the problem of modifying the default character set encoding of MySQL. After a long time, I had to solve the problem and record it. I don't have to worry about it every time.

The command for viewing the MySQL character set is "show variables like '% char % ';".

Taking MySQL5.6 as an example, the default character set is:

During work, you must change all character sets to utf8.

The following is the modification method:

1. Open the installation directory. The default value is "C: \ Program Files \ MySQL Server 5.6 ",

2. Copy A my-default.ini in the current folder and rename it "my. ini ",

3. Add "default-character-set = utf8" to both [mysqld] and [client ",

4. Save the configuration file and restart MySQL.

Log on again in the Command window and check again:

We can see that all of them have been changed to utf8.

The above section describes how to modify the default character set encoding in MySQL. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!