centos7安装MySQL8.0

一、卸载MySQL

1.查看是否有安装的MySQL

rpm -qa | grep -i mysql 或者 yum list install mysql*

2.卸载MySQL

yum remove mysql mysql-server mysql-libs compat-mysql
yum remove mysql-community-release 
rpm -e --nodeps mysql-community-libs-8.0.13-1.el7.x86_64 
rpm -e –nodeps mysql80-community-release-el7-11.noarch

3.删除残余目录

find / -name mysql

rm -rf 上述路径MySQL

4.删除配置文件

rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret

4.1删除开机自启

chkconfig --list | grep -i mysql
chkconfig --del mysqld

二、安装MySQL

1.yum仓库下载MySQL

yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

2.yum安装MySQL（建议配置国内镜像源）

yum install mysql-community-server

3.启动MySQL服务(centos7适用)

systemctl start mysqld

4.查看MySQL初始密码

cat /var/log/mysqld.log | grep password

5.修改MySQL密码（密码最好包含大小写数字符号，否者密码设置无效）

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

6.远程访问授权（以下命令）

create user 'root'@'%' identified with mysql_native_password by '密码';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

7.修改加密规则

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER; 命令修改加密规则，MySql8.0 版本和 5.0 的加密规则不一样，而现在的可视化工具只支持旧的加密方式

8.关闭防火墙

systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl mask firewalld.service

9.安装iptables防火墙

yum -y install iptables-services

10.启动设置防火墙

systemctl enable iptables
systemctl start iptables

11.编辑 /etc/sysconfig/iptables文件

需添加的文本

-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8090 -j ACCEPT

公告