安装MySQL8实战分享

Linux版本：CentOS Linux release 7.7.1908 (Core)

MySQL版本：mysql-8.0.26 社区版

1、下载mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar安装包

2、解压安装包

tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar 

3、卸载系统上的旧mariadb

yum -y remove mariadb-libs.x86_64

4、rpm方式安装rpm

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm 

5、启动mysql

 查看状态

service mysqld start

service mysqld status

6、登陆MySQL

查看临时密码并修改密码cat var/log/mysqld.log

alter USER 'root'@'localhost' IDENTIFIED BY '新密码(必须包含：数字大小写字母特殊字符)';

7、修改MySQL的root用户远程可以登陆

use mysql;

update user set host = "%" where user='root';

刷新生效flush privileges;

8、解决部分客户端无法连接的问题

alter USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root用户的密码';

9、刷新生效

flush privileges;