centos 安装 mysql8.0

1、删除centos自带mariadb

rpm -qa | grep mariadb

#查找mariadb

#可能出现的结果mariadb-libs-5.5.56-2.el7.x86_64

#将查找出来的结果进行强制删除

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

 

2、下载并安装MySQL官方的 Yum Repository

# wget -i -c  https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

# yum -y install mysql80-community-release-el7-1.noarch.rpm

之后就开始安装MySQL服务器

yum -y install mysql-community-server

 

3、安装成功，启动mysql服务

systemctl start  mysqld.service

4、从mysql的日志中找到初始密码

 grep "password" /var/log/mysqld.log  

如：&5i9?dg?ahc14721

登录修改密码： mysql -uroot -p

 

5、修改mysql密码

ALTER user 'root'@'localhost' IDENTIFIED BY 'T4@y,adad_01'

#远程设置

mysql> use mysql;

mysql> update user set host='%' where user='root';

##navicat 
ALTER USER 'root'@'%' IDENTIFIED BY 'T40@years,old_01' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'T40@years,old_01';
FLUSH PRIVILEGES;