Parsing mysql to utf8 still has the problem of garble
- 2020-05-24 06:21:07
- OfStack
Solutions:
1, find the mysql installation directory c:\Program Files\MySQL\MySQL Server under my.ini
2. There are three points in modification 1. It should be noted that only two points [mysql] and [mysqld] can be found in the search.
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3. Save my.ini, find the service in the control panel, and restart mysql service.
1, find the mysql installation directory c:\Program Files\MySQL\MySQL Server under my.ini
2. There are three points in modification 1. It should be noted that only two points [mysql] and [mysqld] can be found in the search.
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3. Save my.ini, find the service in the control panel, and restart mysql service.