如何远程连接数据库

如何远程连接数据库

1设置数据库的远程连接权限

这里连接Linux_centos7的数据库

mysql>use mysql 

//此时查询到root的连接权限是本地的，我们修改为任意主机可连
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+

修改root远程连接权限为任意主机

mysql> update user set host = '%' where user = 'root';

#此时修改成功
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+

然后刷新 退出mysql

mysql>flush privileges;
mysql>exit

2关闭Linux系统的防火墙

查询linux的防火墙状态

[root@centos102 mysql-files]# systemctl status firewalld

如果是active(running)，就关闭

[root@centos102 mysql-files]# systemctl stop firewalld

3连接数据库

在另一个主机，根据本linux的 主机号、账户密码、端口号连接数据库