centos rpm离线安装mysql8.0

wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar

解压包

tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar

检索是否已存在mysql

rpm -qa | grep -i mariadb

移除mysql相关依赖包

rpm -ev --nodeps mariadb-libs-5.5.65-1.el7.x86_64

开始安装，顺序依次执行安装rpm包

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm

启动

systemctl start mysqld

查看初始密码

cat /var/log/mysqld.log | grep password

登录

mysql -u root -p

更改密码、设置可远程登录、刷新权限。

ALTER user 'root'@'localhost' IDENTIFIED BY '123456';

ALTER user 'root'@'localhost' IDENTIFIED BY 'Root.123456';

use mysql; select host,user from user; update user set host='%' where user ='root';

flush privileges;