CentOS 安装 MySQL

下载 MySQL 安装包

MySQL :: Download MySQL Community Server

安装 MySQL

解压安装包

rpm -ivh 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 uer '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

使用 DBeaver 连接 MySQL