Modify MySQL Default character set encoding and mysql character set encoding

Modify MySQL Default character set encoding and mysql character set encoding

It's better to remember it than to write it down. A lot of things were not written down at the time, so I forgot it. The next time I use it, I have to waste a lot of time to solve it. 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.

Done.