第一步安装mysql(三步流程):
1. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.yum -y install mysql57-community-release-el7-10.noarch.rpm
3.yum -y install mysql-community-server
第二步:配置mysql
1.运行mysql: systemctl start mysqld.service
2.获取密码:cat /var/log/mysqld.log | grep password,然后登陆
3.修改密码:
1:设置密码之前设置全局参数,否则密码会提示不安全:
set global validate_password_policy=0;(这两个参数是5.7版本,如果你是8.0版本,需要改password_policy为password.policy,下面同理)
set global validate_password_length=1;
2.修改密码:alter user 'root'@'localhost' identified by 'yourpassword';(yourpassword代表你的密码)
3.修改允许所有主机连接:update user set Host='%' where Host='localhost' and User = 'root';
4.刷新权限:flush privlileges;
4.设置防火墙端口:firewall-cmd --zone=public --add-port=80/tcp --permanent,然后重载一下:firewall-cmd --reload
用navicat远程连接,OK!