CentOS7在线安装并配置Mysql57

记录下CentOS7怎么在线安装mysql57，默认CentOS7是mariadb数据库，但是有些项目需要mysql57，这就很不友好！

环境：CentOS7

一、官网下载Mysql57的RPM包

官网下载链接：http://repo.mysql.com/

二、将下载的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并下载mysql

rpm -ivh mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-community-server

五、启动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