Mysql modifies the default character set encoding method _mysql

Today, I encountered the problem of modifying the MySQL default character set code, toss a half-day resolved, and quickly recorded, then do not have to toss every time.

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

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

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

Here's how to modify it:

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

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

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

4. Save the configuration file and restart MySQL.

Command window to log in again, and then look at:

We have seen it all changed to UTF8.

The above is a small set to introduce the MySQL modify the default character encoding method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!