How to modify the MySQL character set

1. Check the character set of MySQL

show variables like '%char%'; 

2. Modify the MySQL configuration file

It's not the installation directory, it's the data directory. I opened it with sublime.

After entering, add configuration in three places.

First one:

[client]
  default-character-set=utf8

Second one:

[mysql]
 default-character-set=utf8

The third one:

[mysqld]
 character-set-client-handshake = FALSE 
 character-set-server = utf8
 collation-server = utf8_unicode_ci 
 init_connect='SET NAMES utf8'

Above:

save

3. Restart MySQL service

This computer -> Manage -> Services and Applications -> Services -> MySQL Service -> Restart

4. Log in to MySQL

Enter the command

show variables like '%char%'; 

Done

The above is the details of how to modify the MySQL character set. For more information about modifying the MySQL character set, please pay attention to other related articles on 123WORDPRESS.COM!