VMware Virtual Network Mapping Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: VMware 虚拟网络映射 Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

| username: kino

[Test Environment for TiDB]
[TiDB Version] 6.5.2
[Encountered Issue: Problem Description and Impact]
Installed VMware on Windows 10 (192.168.1.121), then successfully deployed the cluster by creating 9 virtual machines in VMware. The network connection uses NAT mode, with the subnet being 192.168.43.xxx.

Within the dedicated subnet of the virtual machines (192.168.43.xxx), I can access the tidb_server (192.168.43.140:4000) using the MySQL client.

To allow access to tidb_server and Grafana from other subnets, I configured port mapping in VMware’s virtual network editor.

The result is:
Computers from other subnets can access Grafana (http://192.168.1.121:3000) through VMware’s port mapping and can also use telnet to log in to 192.168.1.121:4000, but cannot access 192.168.1.121:4000 using the MySQL client.

The error message is:
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

Please advise, any help would be greatly appreciated!

2
| username: kino | Original post link

Problem solved. The port mapping in VMware didn’t work. Configure port forwarding directly on the Windows host where VMware is located:

netsh interface portproxy add v4tov4 listenaddress=192.168.1.121 listenport=4000 connectaddress=192.168.43.140 connectport=4000
3
| username: Billmay表妹 | Original post link

Great~ Congratulations on solving a problem by yourself~

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.