1)下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
2)检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
3)改变默认安装的mysql版本
vim /etc/yum.repos.d/mysql-community.repo
比如要安装5.6版本,将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可。
4)安装MySQL
yum install mysql-community-server
5)启动MySQL服务
systemctl start mysqld查看MySQL的启动状态systemctl status mysqld
6)进入mysql后出错:
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
执行 flush privileges; 重新修改
7)关闭防火墙:
sudo systemctl stop firewalld.service
8)关闭开机启动:
sudo systemctl disable firewalld.service
9)安装iptables防火墙
sudo yum install iptables-services
10)配置iptables防火墙,打开指定端口
11)设置iptables防火墙开机启动
sudo systemctl enable iptables
修改Linux系统防火墙配置需要修改 /etc/sysconfig/iptables 这个文件,如果要开放哪个端口,在里面添加一条
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
就可以了,其中 8080 是要开放的端口号,然后重新启动linux的防火墙服务,
初始化iptables下
iptables -F
service iptables save
service iptables restart