Remote access to MySQL/SQL Server
Update Date:2025-05-28 17:23:53
When the database server is deployed in the intranet, the devices in the local area network can easily access the database. If the network environment where the database server is located does not have public network IP, or does not have router/optical cat management rights, the database of the internal network can be accessed from the external network through the internal network of the Aweshell.
The following is an example of SQL Server to introduce Aweshell intranet penetration to achieve external network access to the intranet database:
1. Open Remote Desktop
Deploy the SQL Server database locally and ensure that the devices in the local area network can be accessed through the intranet IP address.
2. Add regular Application Class Map
(1) Install and log in the Aweray Aweshell client on the server where the database is deployed or on the terminal device that can access the database intranet. On the [Intranet Penetration] of the client, click " + " to add a mapping and jump to the Aweshell management platform to fill in the new mapping information.
(2) Add regular application mapping
Content | Description | |
---|---|---|
Mapping Settings | regular application | Suitable for remote desktop, SSH, database, online games and other common TCP applications, does not support browser access |
Basic Settings | Application name | Custom mapping name |
Mapping protocol | Select TCP | |
Internal and external network settings | Extranet domain name | Select the domain name used to remotely access the database from the Internet. |
Extranet port | Dynamic port, automatically assigned port number; fixed port number can be selected according to the actual situation | |
Intranet host | IP address of the database accessed from the intranet | |
Intranet port | Port number of the database, SQL Server:1433;MySQL:3306 |
If you have bandwidth or security requirements, you can click [More Settings] to set the relevant settings.
Content | Description | |
---|---|---|
Bandwidth Settings | Bandwidth | By default, the corresponding bandwidth is allocated according to the account level, or you can pay extra according to actual needs. |
Nighttime bandwidth acceleration | from 8:00 to 8:00 the next day, the bandwidth speed is increased by 100, and the speed is not less than 5Mbps; The larger the bandwidth base, the faster the night | |
Security Settings | Access rules | Support mapping setting access password for secondary verification access; Support setting specified password, IP, time, browser, system and other methods to apply access restriction [**Click to view access control help tutorial**] |
(3) After the mapping is added, the database can be accessed through the external network address.
3. Connect to the database remotely
Copy the external network address and paste it into the database login window to log in and connect to the database.
Did the content of the document help you?
If you encounter product-related problems, you can consult Online customer service Ask for help.