centos7 mysql5.7安装

安装

https://www.cnblogs.com/luohanguo/p/9045391.html

解决centOS的mysql 1130连接错误

https://blog.csdn.net/sikefeng/article/details/79597273

命令总结

## 安装包准备
yum -y install wget
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

## 启动
systemctl start  mysqld.service
systemctl status mysqld.service

## 登录
grep "password" /var/log/mysqld.log
mysql -uroot -p

## 修改密码
set global validate_password_policy=0;
set global validate_password_length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
exit  
systemctl restart mysqld
service mysqld status

## 卸载更新
yum -y remove mysql57-community-release-el7-10.noarch
## 重新登录
mysql -uroot -p

## 其他主机登录授权
use mysql;
select 'host' from user where user='root'; 
update user set host = '%' where user ='root'; 
flush privileges;
select 'host' from user where user='root';
exit  
systemctl restart mysqld
service mysqld status

测试成功远程主机