Centos8 安装 Mysql8

1. 查看MySQL是否安装

rpm -qa | grep -i mysql

     2. 如果安装将其删除

yum -y remove MySQL-*

     3.  查找MySQL相关目录

find / -name mysql 

   4.  删除相关目录下文件

rm -rf 目录

   5.   删除my.cnf

rm -rf /etc/my.cnf

  6.  删除.mysql_sercret

rm -rf /root/.mysql_sercret

   7. 更新yum

yum update

   8.  在local目录下创建一个mysql目录

mkdir mysql

   9. 进入mysql文件，下载mysql 

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

   10.  安装软件源

rpm -Uvh  https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

   11 安装mysql

yum module disable mysql    

yum install mysql-community-server

 12 启动mysql服务

service mysqld start

13 查看mysql服务状态

service mysqld status

  14  查看mysql临时密码

grep 'temporary password' /var/log/mysqld.log

15  临时密码登录

mysql -uroot -p

16  用临时密码修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '临时密码';

17 设置修改密码配置

set global validate_password.length=0;
set global validate_password.policy=0;

18  修改改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

19 重启MySQL服务

service mysqld stop
service mysqld start

 20  进入mysql库并执行如下sql

use mysql;
update user set host = '%' where user = 'root' and host='localhost';

//允许任何远程主机都可以访问数据库
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

//服务生效
flush privileges;