Problem:To Connect with MySQL in Virtual PC Environment

时间:2022-04-02 07:23:58

I'm trying to build a 1:n dev environment,with the help of Vsever(just like VMware worked on sever)

Things seem to be OK while I copy the os mirror to the virtual pc and install it.

Building My IDE(python+npp), Installing libraries needed, vcredist_x64 and WAMP are also small case.

The IPs config just like this:

10.10.x.x is the ip of Virtual PCs and 172.16.x.x are of Real PCs.

The net gate join 10.10.10.1 with 172.16.1.1 so that the V and the R are combined as one.

10.10.10.130---------------------|

10.10.10.131---------------------|

10.10.10.132---------------------|

10.10.10.133---------------------|

10.10.10.134---------------------|

                 |

   NET GATE:   10.10.10.1--::---172.16.1.1

                 |

172.16.6.66(+10.10.10.197)----|

After all above,I start the WAMPserver service and got an green status, it worked!

check into my pc,type http://10.10.10.130:80 in the broswer::The traditional WAMP index page appears--connecting with virtual pc by http is OK!

reverse:

  start WAMPserver in real PC and type http://172.16.6.66:80 can get the same result

It seems that all things are OK,but, while I try to use Navicat connect whit mysql in 10.10.10.130:3306, I got a 10061.

To my confused,It's ok to connect 172.16.6.66:3306 with Navicat from Virtual PC(10.10.10.130).

Just Like This:

From Http:(In Broswer)

  10.10.10.x <--------------------> 172.16.6.66

From IP:PORT(In Navicat)

  10.10.10.x  ---------------------> 172.16.6.66

  10.10.10.x  <-----------X--------- 172.16.6.66

I wander if there are some fucking configuration in the IP_conf

After several trys ...orz

Chart with friends in qq group and XXX says that it may because of the fire wall configuration.

Googled it!

In The Fire Wall Configuration:

  build a new port rule that allow the 3306 blablablabla.

  named the rule with a XXX name and save

OVER~