Can't get external Connection - MySQL (Port 3306)

This thread has been locked for further replies. You can start a new thread to share your ideas or ask questions.

Can't get external Connection - MySQL (Port 3306)

This thread has been locked for further replies. You can start a new thread to share your ideas or ask questions.
Can't get external Connection - MySQL (Port 3306)
Can't get external Connection - MySQL (Port 3306)
2020-04-14 14:44:18 - last edited 2021-04-19 11:20:12
Model: TL-R600VPN  
Hardware Version: V7
Firmware Version: 4.0.3 Build 20190227 Rel.48206

Hi there, how are you?

I use MySQL here, but I cant connect remotely to backup the DB in other PC.

 

Already done: Transmisison > NAT > Virtual Server and created a new one as bellow: 

 

ID: 1
Name: MySQL
Interface: WAN1,2,3,4
Ext Port: 3306
Int Port: 3306
Int Server IP: 192.168.0.12
Protocol: ALL
Status: Enabled

 


Physical Server is 192.168.0.12 (DHCP reserved) - OK.

Virtual Server Created 3306  - OK
Physical Server Firewall Permissions to 3306 - OK
 

But still can't connect to MySQL by 3306 port.

Already tried to disable both firewall (router + physical server) and there is no connection at all...
 

Any ideias?

Thank you


 


 

  0      
  0      
#1
Options
1 Reply
Re:Can't get external Connection - MySQL (Port 3306)
2020-04-15 03:36:26 - last edited 2021-04-19 11:20:12

@Marson 

 

You can do a simple test. Install HFS on your PC. Set the port as 3309 for HFS. Then change the Int Server IP: 192.168.0.12 to the IP address of HFS. Check if you can access HFS from external network. This is for checking if the virtual server can work.

 

If you don't want to use HFS for testing, you can check whether your MySQL can be accessed from the same network. Make sure MySQL work normally.

  0  
  0  
#2
Options