1.下载MySQL源安装包:
wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'
2.安装MySQL源:
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
3.安装MySQL服务器:
yum install -y mysql-community-server
4.启动MySQL服务:
service mysqld start
5.查看root用户初始密码:
grep "password" /var/log/mysqld.log
6.登录root用户:
mysql -uroot -p'FfNz)5?T0e8y'
7.修改root 密码为xxxx:
SET PASSWORD FOR root@localhost = 'xxxx';
8.修改root用户host属性为%(允许任何ip远程登录):
update mysql.user set host = '%' where user = 'root';
9.开启系统防火墙:
systemctl start firewalld
10.开放MySQL服务器3306端口:
firewall-cmd --zone=public --add-port=3306/tcp --permanent
11.重新加载防火墙规则:
firewall-cmd --reload
12.重启数据库服务器:
service mysqld -restart