How to change the encoding to utf-8 in mysql version 5.7 under windows

Preface

I just started learning MySQL and downloaded the latest version 5.7.14 from the official website. When I used cmd to enter Chinese, an error occurred, so I started to modify the MySQL default encoding (under Windows). Let's take a look at the detailed modification method.

Here’s how

First, view the MySQL character set information by show variables like 'character_set_%';

The default encoding is latin1

Then close the database

Find the my.ini file in the mysql installation directory

Add it

[client]
default-character-set=utf8

Add under [mysqld]

character-set-server=utf8

Restart mysql

You can change the default encoding of the MySQL database to utf-8

Many resources on the Internet are added under [mysqld]

default-character-set=utf8

If this change is made, the 5.7 version of MySQL will not be able to open

So change it to

character-set-server=utf8

Note: After the modification, all data in the database must be deleted before it can be used.

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.