CENTOS7用RPM安装MYSQL8.0方法

1、卸载之前安装的mariadb
rpm -qa |grep mariadb 查看已安装的mariadb
rpm -e mariadb-libs-5.xxx  按提示文件名卸载mariadb
rpm -qa |grep mariadb   再查看mariadb是否全部卸载完

2、上传MYSQL8.0安装包，并解压：
cd /usr/local/
mkdir mysql
cd mysql
把下载好的安装包通过Mobaxterm软件上传到MYSQL这个目录
解压软件 
tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
提示如下：
mysql-community-client-8.0.23-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm
mysql-community-common-8.0.23-1.el7.x86_64.rpm
mysql-community-devel-8.0.23-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.23-1.el7.x86_64.rpm
mysql-community-libs-8.0.23-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.23-1.el7.x86_64.rpm
mysql-community-server-8.0.23-1.el7.x86_64.rpm
mysql-community-test-8.0.23-1.el7.x86_64.rpm

安装下面几个包：
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm --nodeps --force

查看已安装包
rpm -qa | grep mysql
提示如下：
mysql-community-libs-8.0.23-1.el7.x86_64
mysql-community-common-8.0.23-1.el7.x86_64
mysql-community-server-8.0.23-1.el7.x86_64
mysql80-community-release-el7-1.noarch
mysql-community-client-8.0.23-1.el7.x86_64
 

2、对MYSQL数据库进行实始化等相关配置：
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
cat /var/log/mysqld.log | grep password
提示如下：
2021-04-14T08:20:26.712099Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: S=Pm!&Xyq2jh
2021-04-21T02:48:46.640364Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: hoxg2fL-r1Fx最后这个就是初始密码
登陆MYSQL，修改初始化密码：
mysql -uroo -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';（修改ROOT账号的密码为root）

3、进行远程访问授权：

mysql> create user 'root'@'%' identified with mysql_native_password by 'root';

mysql> grant all privileges on *.* to 'root'@'%' with grant option;

mysql> flush privileges;

4、修改加密规则，MYSQL8.0与5.0的加密不一样，面现在可视化工具只支持旧的加密方式：
masql > ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
mysql > flush privileges;
mysql > select version();

 

后话：

另外也有人初始化时，用下面第一行这个命令进行空密码设置（我没度过）。