MySQL数据库安装
Windows版
安装包地址
链接:https://pan.baidu.com/s/1Yfef3OVZDtjn9vtshH3iYQ
提取码:zkr7
安装流程
1.无需安装下载压缩包后,自定义解压路径(可以按照我定义的路径)
E:\BigData\software
2.进行环境变量的配置
鼠标右键点击桌边此电脑图标 >> 选择右侧导航栏的高级系统设置>>选择环境变量>>双击系统变量Path>>在系统变量末尾添加MySQL的bin路径
3.点击E:\BigData\software\mysql-5.6.26-winx64目录下的脚本文件 启动.bat 即可
4.数据库默认账号为root 密码为空
Windows版MySQL字符问题解决
进入数据库后输入命令
mysql> show variables like '%char%';
发现部分字符集非utf-8
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | E:\BigData\software\mysql-5.6.26-winx64\share\charsets\ |
+--------------------------+---------------------------------------------------------+
将E:\BigData\software\mysql-5.6.26-winx64\my.ini的最后一段修改为如下图
mysql> show variables like '%char%';
再次执行命令发现字符集恢复正常
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | E:\BigData\software\mysql-5.6.26-winx64\share\charsets\ |
+--------------------------+---------------------------------------------------------+