liunx下mysql远程连接

1.先修改mysqluser表中的root用户的host

ysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
###刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

2.查看liunx下的防火墙状态，并开启3306的端口号。

//查看防火墙的状态
[root@localhost ~]#  firewall-cmd --state
running
//关闭防火墙
[root@localhost ~]# systemctl stop firewalld.service
//查看3306端口是否开启
firewall-cmd --query-port=3306/tcp
 ###开启防火墙设置端口
systemctl start firewalld.service
 #### zone --作用域
 #### add-port=80/tcp--添加端口，格式为：端口/通讯协议
 #### permanent--永久生效，没有此参数重启后失效
firewall-cmd --zone=public --add-port=3306/tcp --permanent
 ####开启3306端口后，workbench或naivcat 就能连接到MySQL数据库了