Linux-部署mysql
1. 下载 mysql 安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
这一步本人是在window下载,通过ftp 传送到Linux root目录下 (https://www.cnblogs.com/yimihua-kai/p/11663192.html)
2. 安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
4. 安装
yum install mysql-community-server
5. 启动
systemctl start mysqld
6. 获取临时登录密码
grep 'temporary password' /var/log/mysqld.lo
7. 用临时登录密码登录mysql
mysql –u root –p
Password:填写临时登录密码
8. 修改密码
set password =password(‘123456’)
出现问题:ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements。
解决方案:密码长度限制问题
set global validate_password_policy=0 (修改validate_password_policy参数的值)
set global validate_password_length=1 (validate_password_length(密码长度))
再次修改密码:Mysqy->set password =password(‘123456’)
9. 授权,可以使用root远程登录mysql,不限定IP地址
->GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY “123456”;
10. 重新加载权限数据
flush privileges;
exit
11. 开机自启动 mysql
systemctl enable mysqld
systemctl daemon-reload
12. 添加防火墙白名单
#配置端口访问
firewall-cmd --permanent --zone=public --add-port=3306/tcp
#reload配置生效
firewall-cmd –reload
查看所有打开的端口:
firewall-cmd --zone=public --list-ports
查看状态: systemctl status firewalld
重启服务: systemctl restart firewalld