本文已参与「新人创作礼」活动，一起开启掘金创作之路。
下载 MySQL 安装包
MySQL :: Download MySQL Community Server
安装 MySQL
解压安装包
tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar
安装
安装 mysql-community-common-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm
安装 mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
安装 mysql-community-libs-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm
安装 mysql-community-client-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm
安装 mysql-community-server-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm
数据库配置
初始化 MySQL
# 初始化数据库及相关配置
mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;
# 查看数据库密码
cat /var/log/mysqld.log |grep password
修改密码
使用上一步查询到的密码登录数据库，修改密码
alter user 'root'@'localhost' identified with mysql_native_password by '你的密码';
允许远程访问
create user 'root'@'%' identified with mysql_native_password by '你的密码';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
修改加密规则
alter user 'root'@'localhost' identified by '你的密码' PASSWORD EXPIRE NEVER;
flush privileges;
开放 3306 端口
关闭 firewall
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl mask firewalld.service
安装 iptables
yum install -y iptables-services
配置 iptables
# 启动
systemctl enable iptables
systemctl start iptables
开放 3306 端口
vim /etc/sysconfig/iptables
- iptables 添加 3306 端口
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
- 重启 iptables
service iptables restart
