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;