Centos7安装mysql8.0.16

一、官网复制安装源地址：
  1、进入官网地址：https://dev.mysql.com/downloads/repo/yum/
二、创建mysql文件夹 

cd /usr/local
mkdir mysql

三、使用命令“yum install wget 安装wget，接下来在线安装mysql。使用命令

wget http://dev.mysql.com/get/Downloads/mysql80-community-release-el7-3.noarch.rpm

四、安装mysql80-community-release-el7-3.noarch.rpm包。使用命令

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

五、使用命令 “yum install mysql-community-server”安装mysql。安装过程中提示 Is this ok [y/d/N]: 直接属于y即可，请耐心等待安装完成

yum install mysql-community-server

六、安装完成后启动mysql服务，生成随机密码，可以使用这密码登录数据库,随机密码：y1.5iR%iFoF+

systemctl start mysqld
grep 'temporary password' /var/log/mysqld.log

>>2021-11-05T01:50:44.907219Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: y1.5iR%iFoF+

七、更新root密码  
mysql -u root -p 回车 输入 上一步的随机密码登录
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码（包含大小写、数字和特殊字符）';
 

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa@123456';

八、设置远程登录并授权

CREATE USER 'root'@'%' IDENTIFIED BY 'Aa@123456';
GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;

九、更新root密码否则，远程登录会报错

alter user 'root'@'%' identified with mysql_native_password by 'Aa@123456';

十、设置开机启动

systemctl enable mysqld
systemctl daemon-reload

十一 、重新安装mysql，卸载命令共三条如下：

yum remove mysql mysql-server mysql-libs compat-mysql51
rm -rf /var/lib/mysql
rm /etc/my.cnf