1、移除安装的MYSQL

bash
yum remove mysql -y
# 查找残留文件，rm -rf 移除文件
find / -name mysql

2、下载MYSQL包

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

yum install mysql80-community-release-el8-4.noarch.rpm

3、查看MYSQL源是否安装成功

bash
yum repolist enabled | grep "mysql.*-community.*"

4、禁用Centos8自带MYSQL模块

默认情况下执行 yum install mysql-community-server 会安装不上

异常1： No match for argument: mysql-community-server 异常2：All matches were filtered out by modular filtering for argument: mysql-community-server. Error: Unable to find a match: mysql-community-server

解决方案：

bash
yum module disable mysql

5、安装MYSQL

bash
sudo yum --enablerepo=mysql80-community install mysql-community-server -y
# 表名忽略大小写
# 在/etc/my.cnf 中加入 lower_case_table_names=1
vim /etc/my.cnf
# 开机自启动
sudo systemctl enable mysqld
# 启动MYSQL服务
sudo systemctl start mysqld
# 查看MYSQL临时密码
cat /var/log/mysqld.log | grep password
# 登录
mysql -uroot -p

#修改默认密码
alter user 'root'@'localhost' identified by '新密码';

# 修改外部登录权限
use mysql;
update user set host='%' where user='root';

# 刷新权限
flush privileges;