- 在命令窗口打开mysql数据库查看编码
1.cmd
2.mysql -uroot -p + 数据库密码
3.show variables like ‘cha%’ ;(查看编码情况)
图下是修改之前:
mysql> show variables like ‘character_set_%’;
±-------------------------±------------------------------------------+ | Variable_name | Value
|
±-------------------------±------------------------------------------+ | character_set_client | gbk
| | character_set_connection | gbk
| | character_set_database | latin1
| | character_set_filesystem | binary
| | character_set_results | gbk
| | character_set_server | latin1
| | character_set_system | utf8
| | character_sets_dir | D:\MySQL\MySQL Server
5.7\share\charsets\ |
±-------------------------±------------------------------------------+
- 用文本编辑器打开mysq的配置文件my.ini 修改如下:
- 命令提示符(用管理员身份打开)
输入:
1.net stop mysql (mysql名字自己win +r 输入services.msc去看)
2.net start mysql (mysql名字自己win +r 输入services.msc去看)
- 重复第一个步骤查看编码情况
1.cmd
2.mysql -uroot -p + 数据库密码
3.show variables like ‘chara%’;
如图更改过后: