#创建文件夹
mkdir /usr/local/mysql
cd /usr/local/mysql/
#检查是否已经过mysql
yum list installed | grep mysql
#已安装,则清除
yum -y remove mysql-libs.x86_64
#下载mysql5.7 rpm源
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
#安装下载好的rpm包
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
#安装mysql(出现 GPG keys 问题，采用下方安装方法)
yum install -y mysql-server
#安装mysql(不检查Public Key 强制安装)
yum install --nogpgcheck -y mysql-server
#查看下mysql的版本，确定是否安装成功
mysql -V
#运行mysql
service mysqld start
#取得mysql初始化随机密码
grep "password" /var/log/mysqld.log
#登录mysql
mysql -u root -p
#设置密码的验证强度等级
set global validate_password_policy=LOW;
#设置密码长度最少为6
set global validate_password_length=6;
#修改默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
#使用mysql库
use mysql;
#查询访问权限信息
select user,host from user;
#将root用户的host改为%，%表示允许任意host访问
update user set host="%" where user="root";
#使本次修改立即生效
flush privileges;
#退出Mysql
exit;
#设置开机启动
systemctl enable mysqld
#重新加载开机启动配置
systemctl daemon-reload
#重启mysql
service mysqld restart
# yum快捷安装
yum repolist enabled | grep "mysql.*-community.*"
yum -y install mysql-community-server
