承接上文
4查看密码,登录MySQL,修改密码,设置远程访问用户组,开放3306端口。
4.1查看默认的密码
cat /var/log/mysqld.log | grep password
A temporary password is generated for root@localhost: W?pd%*8k<xeI
其中
W?pd%*8k<xeI
就是密码
4.2登录MySQL
mysql -uroot -p
4.3修改密码
通过ALTER修改默认密码为'root'
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
//
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'A';
A是你怎么想设置的密码,MySQL有自己的密码规范。可以在官网上查看,也可以直接搜。
4.4设置远程访问用户组
mysql> create user 'root'@'%' identified with mysql_native_password by 'root';
//密码可以设置自己喜欢的,展示是root
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4.5开放端口
退出MySQL
exit
4.5.1iptables的开放端口
[root@localhost ~]# vim /etc/sysconfig/iptables
========================================================================
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
//添加的3306端口
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8090 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
========================================================================
[root@localhost ~]# systemctl restart iptables.service
[root@localhost ~]# systemctl enable iptables.service
可以选择安装,建议firewalldhttps://blog.csdn.net/rj2012001/article/details/121783690
4.5.2 firewalld
可以通过Navicat 15 for MySQL进行远程访问