centos7下载安装mysql5.7.22(yum安装)

原文连接：https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-7
原文连接：https://blog.csdn.net/lihao21/article/details/80692068
官方连接：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

下载mysql安装包
wget http://repo.mysql.com/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm

更新yum软件包
yum check-update
更新系统
yum update

安装mysql
yum install mysql mysql-server

启动mysql
sudo systemctl start mysqld

检查mysql状态
sudo systemctl status mysqld

有红框的时间就是状态正常

查看临时密码
sudo grep ‘temporary password’ /var/log/mysqld.log

配置mysql
sudo mysql_secure_installation

密码就设置为（设置了半天）
MyNewPass4!

查询mysql版本号
mysqladmin -u root -p version

开放其他地址连接
mysql -u root -p
mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>grant all privileges on . to [email protected]’%’ identified by “MyNewPass4!”;
mysql>flush privileges;

开放端口-防火墙

firewall-cmd --get-active-zones

添加端口到防火墙中

firewall-cmd --zone=public --add-port=3306/tcp --permanent

防火墙重新读取端口列表

firewall-cmd --reload

随后测试可以连接成功

ps:MYSQL5.7版本sql_mode=only_full_group_by问题
先用select @@sql_mode;查询，复制这个值，在my.cnf中添加配置项（把查询到的值删掉only_full_group_by这个选项，其他的都复制过去）：
vi /etc/my.cnf

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启mysql服务
重启服务：systemctl restart mysqld.service
停止服务：systemctl stop mysqld.service
启动服务：systemctl start mysqld.service
查看服务：systemctl status mysqld.service