Modify MySQL default character set encoding

Good mind is better than rotten pen, a lot of things at that time did not remember, after the forgotten, the next time you have to waste a lot of time to solve. Today again encountered the change MySQL default character set encoding problem, toss a half-day solved, quickly record down, later don't have to toss each time.

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

In MySQL5.6, for example, the default character set is:

You need to modify the character set all to UTF8 at work.

Here's how to modify it:

1. Open the installation directory, default to "C:\Program files\mysql\mysql Server 5.6",

2. Copy the "My-default.ini" in the current folder and rename it to "My.ini",

3. Add a "Default-character-set=utf8" under [mysqld] and [client],

4. Save the configuration file and restart MySQL.

Command window to log in again and check again:

We saw that all had been changed to UTF8.

Get.

Modify MySQL default character set encoding