Tools

Windows安装MySQL5.7.30

阅读：344 发布：2020-07-20 作者：lypeng

#### 前提
公司测试环境数据版本升级到5.7了，有个group by报错
```
SELECT list is not in GROUP BY clause and contains nonaggregated column xxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by；
```
于是，升级下本地的MySQL，测试下这个group by

官方下载地址：
32位：https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.30-win32.zip?_blank
64位：https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.30-winx64.zip?_blank

#### 下载后解压到 D:\phpStudy\MySQL

#### 新建my.ini配置文件
```
[mysql]
default-character-set=utf8

[mysqld]
port = 3306
basedir="D:/phpStudy/MySQL/"
datadir="D:/phpStudy/MySQL/data/"

max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
```

#### 初始化data目录
`./mysqld.exe --initialize-insecure`

#### 更改root密码
```
mysql -u root --skip-password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
```

#### 复制旧的data目录中的文件，到新的data目录
ib开头文件除外，performance_schema,mysql等主表除外~

#### 附注
看官方文档，能够最快解决问题~
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html?_blank

------本文结束感谢阅读------

上一篇：MySQL教程之concat以及group_concat的用法

下一篇：Mysql5.7查看已经执行的sql语句