下载Mysql yum repo配置文件:
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
安装Mysql repo
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件
mysql-community.repo
mysql-community-source.repo
整体如下图:
切换到/etc/yum.repos.d/目录下,执行:
cd /etc/yum.repos.d/
yum install mysql-server
启动MySQL:
systemctl start mysqld
获取MySQL临时密码:
grep 'temporary password' /var/log/mysqld.log
登录MySQL,修改root密码:
执行 mysql -u root -p,输入获取的临时密码
执行修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
或
set password=password("密码");
创建远程用户并授权数据库:
grant all privileges on [dbname].[tablename] to [username]@"%" identified by "password";
flush privileges;
设置MySQL开机启动:
systemctl enable mysqld
把MySQL端口加入防火墙
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重载防火墙
firewall-cmd --reload
查看端口情况:
firewall-cmd --list-port