Shulou(Shulou.com)06/01 Report--

Public network accesses internal network MySQL database

The MySQL database is installed on the intranet host, which can only be accessed in the local area network. How can the local MySQL database be accessed from the public network?

This article describes the specific steps to implement using holer.

1. Preparation 1.1 install and start the MySQL database

The default installed MySQL database port is 3306.

two。 Implement step 2.1 download and extract the holer package

Holer package: holer-xxx.tar.gz

Holer supports a variety of OS system platforms, please select the holer package that matches the local OS type.

2.2 get holer access key information

Apply for your own holer access key on the holer official website or use access key information publicly available in the open source community.

For example, the holer information you applied for is as follows. Here we take the holer information as an example:

-Holer Client: holerdemo@gmail.comAccess Key: 8866daebe02846t88s166733595fff5d-Internet Address: holer.org:65014Local Address: 127.0.0.1 purl 3306 -2.3 start the holer service

Windows system platform:

Open the CMD console and go to the directory where the executable is located to execute the command:

Holer-windows-xxx.exe-k 8866daebe02846t88s166733595fff5d

Linux or other system platforms:

Execute the command: nohup. / holer-xxx-xxx-k 8866daebe02846t88s166733595fff5d

2.4 access the mapped public network address

Enter on the database client

Hostname: holer.org port number: 65014

This allows you to access the local MySQL database from the public network.

2.5 question consultation and help

When you encounter problems in the process of using holer, you can first check the log information printed by the holer console, so that it is easy to find out the specific cause of the problem.

For more examples of using holer, please refer to the technical materials related to holer.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.