1.官网下载Mysql安装源:Mysql8.0
2.安装Mysql源yum -y install mysql80-community-release-el7-3.noarch.rpm
3.安装Mysqlyum -y install mysql-community-server
4.启动Mysqlservice mysqld start
6.停止Mysqlservice mysqld stop
6.查看Mysql运行状态service mysqld status
7.查看初始密码sudo grep 'temporary password' /var/log/mysqld.log
8.登录Mysqlmysql -uroot -p
9.修改root登录密码[mysql8.0以上密码策略限制必须要大小写加数字特殊符号]alter user'root'@'localhost' identified with mysql_native_password by '新密码';
10.修改Mysql访问限制update user set Host ='%' where User = "root";
11.刷新Mysqlflush privileges;
12.新增用户create user 'yiiwang'@'%' mysql_native_password identified by '密码';
Mysql8.0默认使用caching_sha2_password加密
13.赋值权限grant all on . to 'yiiwang'@'%' ;
14.设置自动启动systemctl enable mysqld
systemctl daemon-reload