外网连接MYSQL

Question

我在从外部网络连接到 mysql 时遇到问题。如果我要在本地连接它，就可以完成。假设我是主持人，我应该做什么？

Answer 1

您需要在路由器中的端口 3306 上设置端口转发到本地 IP 端口 3306。您需要向用户授予权限以允许从外部 IP 进行访问。

例如:

CREATE DATABASE Test;
GRANT ALL ON Test.* TO remoteUser@'10.11.12.100' IDENTIFIED BY 'PASSWORD123';

或所有表格:

GRANT ALL PRIVILEGES ON *.* to remoteUser@10.11.12.100 IDENTIFIED BY "PASSWORD123";

如果这不起作用，请检查您的 MySQL 服务器设置，示例/etc/mysql/my.cnf (Debian)

设置文件:

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306 - CHECK THAT PORT IS CORRECT
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/English
bind-address    = 1.1.1.1 CHECK THAT IP IS CORRECT
skip-networking = DELETE OR  # FRONT OF IT