centos7.9在线安装mysql8.0

######################## centos 7.9下mysql 8.0安装 ########################
######################## centos最小化安装工具 #############################
一、安装wget
yum -y install wget
二、安装vim
yum -y install vim-enhanced
三、更换yum源为国内的阿里云源（选择）
1、备份CentOS-Base.repo
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
2、下载新的CentOS-Base.repo 到/etc/yum.repos.d/
CentOS 5：wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-5.repo 或者 curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-5.repo
CentOS 6：wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo 或者 curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
CentOS 7：wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo 或者 curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
3、生成缓存
yum makecache
四、安装ifconfig
ip addr：查看ip
yum -y install net-tools.x86_64
五、安装zip、unzip
yum install -y unzip zip
六、安装rz和sz命令
yum install -y lrzsz
七、安装Tree命令
yum -y install tree
八、安装telnet
yum -y install telnet-server.x86_64
yum -y install telnet.x86_64
yum -y install xinetd.x86_64
systemctl enable xinetd.service
systemctl enable telnet.socket
#接下来启动服务
systemctl start telnet.socket
systemctl start xinetd

########################## 在线安装mysql 8.0 ###############################

1、CentOS命令下载
curl https://repo.mysql.com//mysql80-community-release-el7-6.noarch.rpm > centos7.mysql.rpm
2、安装yum源
yum install centos7.mysql.rpm
3、解决“安装mysql提示公钥尚未安装”
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
4、安装MySQL 8.0
yum install mysql-community-server
5、设置启动和开机自启
systemctl start mysqld
systemctl enable mysqld
6、查看初始密码
cat /var/log/mysqld.log | grep “password”
7、登录
mysql -u root -p
8、修改密码
alter user ‘root’@‘localhost’ identified by ‘!QAZ2wsx’;
9、密码验证策略低要求(0或LOW代表低级)
set global validate_password.policy=0;
10、密码至少要包含的小写字母个数和大写字母个数
set global validate_password.mixed_case_count=0;
11、密码至少要包含的数字个数。
set global validate_password.number_count=0;
12、密码至少要包含的特殊字符数
set global validate_password.special_char_count=0;
13、密码长度
set global validate_password.length=6;
14、修改密码
alter user ‘root’@‘localhost’ identified by ‘123456’;
15、更新任意ip访问
use mysql;
update user set host=‘%’ where user=‘root’;
16、按mysql_native_password加密方式修改密码
alter user ‘root’@‘%’ identified with mysql_native_password by’123456’;
17、刷新权限
FLUSH PRIVILEGES;
18、查看3306端口是否开放
iptables -vnL | grep 3306
如果结果没有或者第三列为drop状态，则使用命令，添加需要监听的端口（临时，关机失效）
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

永久添加
1.添加3306端口（–permanent永久生效，没有此参数重启后失效）
[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
输出success
2.更新防火墙规则
[root@localhost ~]# firewall-cmd --reload
输出success
3.查看端口是否开放
[root@localhost ~]# firewall-cmd --zone=public --query-port=3306/tcp
输出yes
4.查看已开放的端口
[root@localhost ~]# firewall-cmd --zone=public --list-ports
输出3306/tcp
5.删除端口
[root@localhost ~]# firewall-cmd --zone= public --remove-port=3306/tcp --permanent
输出success