CentOS7离线安装并配置Mysql57

部署一些项目的时候会遇到只支持mysql57的问题，但是服务器有没有网络，所以记录下怎么离线安装并配置mysql57

环境：CentOS7

一、官网下载Mysql57的RPM Bundle包

官网下载链接：https://downloads.mysql.com/archives/community/

二、将下载的RPM上传到服务器任意位置，这里我们先上传到/root下

三、查看是否有已安装的mysql或mariadb，有的话卸载掉，没有的话就不管

rpm -qa | grep mariadb
rpm -qa | grep mysql
rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps

四、创建文件夹并解压RPM Bundle包

mkdir mysql57
mv mysql-5.7.11-1.el7.x86_64.rpm-bundle.tar /root/mysql57
cd /root/mysql57
tar -xvf mysql-5.7.11-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.11-1.el7.x86_64.rpm

五、启动mysql并查看、重置密码、修改密码策略

systemctl restart mysqld
cat /var/log/mysqld.log | grep localhost

mysql -u root -p
输入刚才cat出来的初始密码

alter user 'root'@'localhost' identified by 'AbC111@qq.coM'
set global validate_password_policy=0;
set global validate_password_length=0;
flush privileges;

因为mysql57安全策略比较严格，所以密码尽可能复杂点。

六、设置允许远程连接mysql

use mysql;
update user set host='%' where user='root';
flush privileges;
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

七、去除only_full_group_by

默认是有only_full_group_by的，这会导致java起来的时候执行group by命令会报错从而导致启动失败

set @@GLOBAL.sql_mode=
'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set sql_mode=
'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

在/etc/my.cnf里面添加下面一句

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

八、重启mysql并设置mysql开机自启

systemctl restart mysqld
systemctl enable mysqld