mysql5.5安装教程及乱码问题处理

mysql8.0下载安装教程： https://jingyan.baidu.com/article/0bc808fc1fb9761bd585b97d.html

 

mysql5.5安装教程： https://blog.csdn.net/weixin_38239039/article/details/79629984

中文显示乱码问题解决：

1、修改my.ini配置文件 default-character-set=gbk character-set-server=gbk

2、修改数据库系统的编码配置

status;

show variables like '%char%';

set character_set_server='gbk';

set character_set_database='gbk';

以下设置标准方可解决乱码：

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\share\charsets\ |

3、修改好之后创建数据库的时候末尾必须加：

ENGINE= MYISAM CHARACTER SET utf8;