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

This article mainly introduces you to access the local MySQL database tutorial on the external network, hoping to supplement and update some knowledge for you. If you have other questions to understand, you can continue to follow my updated article in the industry information.

Public network accesses internal network MySQL database

Local installation of the MySQL database, can only be accessed in the local area network, how to access the local MySQL database from the external 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 Holer's 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

In this way, you can access the local MySQL database from the external network.

Read the above about the external network access to the local MySQL database tutorials, hoping to give you some help in practical application. Due to the limited space in this article, it is inevitable that there will be deficiencies and need to be supplemented. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

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.