没有webserver的mysql访问（例如Apache）

I was wondering if there is a way to access a database service on a remote computer without having a webserver installed on that computer?

我想知道是否有办法访问远程计算机上的数据库服务而没有在该计算机上安装Web服务器?

Does MYSQL DBMS provide some interface (port) which can be connected directly to, or is a webserver (that forwards the communication) mandatory?

MYSQL DBMS是否提供了一些可以直接连接的接口(端口),或者是一个强制性的网络服务器(转发通信)?

3 个解决方案

#1

MySQL can be access by default on port 3306. Normally this port will be blocked by the firewall though, as it's not good practice to have your DB server accessible to the outside world.

默认情况下,MySQL可以在端口3306*问。通常,此端口将被防火墙阻止,因为让外部世界可以访问您的数据库服务器并不是一个好习惯。

If you want to access a remote database via the command line you can use the mysql client.

如果要通过命令行访问远程数据库,可以使用mysql客户端。

If you're doing this over the internet you should probably use a tunnel or VPN for security.

如果您是通过互联网进行此操作,则应该使用隧道或VPN来提高安全性。

#2

You can connect to MySQL using ODBC. Default Port 3306

您可以使用ODBC连接到MySQL。默认端口3306

#3

As they said. You can connect with mysql using the (default por 3306). You may use mysql client, or the ODBC, JDBC, or ADO.Net interfaces. There are connectors for most of the main programing languages.

正如他们所说。你可以使用(默认的por 3306)连接mysql。您可以使用mysql客户端,或ODBC,JDBC或ADO.Net接口。大多数主要编程语言都有连接器。

If you are looking for a user-friendly tool to use mysql like PHPmyAdmin you may like MYSQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html

如果您正在寻找一个用户友好的工具来使用像PHPmyAdmin这样的mysql,您可能会喜欢MYSQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html

#1