通过网络工作的Wamp服务器 [英] Wamp server that works over a network

问题描述

我有2台计算机.两者都以w7为操作系统.我已经在其中之一上安装了wampserver.我在wampserver上有mysql数据库.然后，我制作了一个vb.net程序以连接到mysql数据库.我已经在两台计算机上都放了程序.我要做的是让这两个程序看到同一台计算机上的同一数据库.为了使他们能够添加，删除，更新那个1数据库.我怎么做?如何联网mysql数据库?我还必须在另一台计算机上安装wampserver吗?我该怎么办?请赐教.

-我的问题已连接到此链接:http://www.rajputbrotherhood.com/tech/software/how-to-access-wampserver-through-lan-local-area-network-or-from-the-server -machine.html

唯一的区别是它不是网站.它是通过Visual Studio制作的Winform. < small></small>

I have 2 computers. Both with w7 as os. I have installed wampserver on one of them. I have mysql database on wampserver. Then I have made a vb.net program to connect to mysql database. I have put the program on both computers. What I want to do is for those two programs to see the same database that is on one computer. For them to be able to add, delete, update that 1 database. How do I do that? How do I network the mysql database? Do I also have to install wampserver on the other computer? What do I do? Please enlighten me.

edit: -my question is connected to this link: http://www.rajputbrotherhood.com/tech/software/how-to-access-wampserver-through-lan-local-area-network-or-from-the-server-machine.html

the only difference is its not a website. Its a winform made through visual studio . Do I need to turn off the firewall where wampserver is installed so that I could access it?<small></small>

推荐答案

Mysql是服务器本身，是否需要关闭安装wampserver的防火墙? ，并监听它自己的端口. wamp的apache部分在这里并不完全重要，因为您没有使用HTTP连接到它. mysql网站上有在Windows上安装的说明，以及非常有用的.net连接器.

我假设您在一台计算机上有mysql数据库，而两台计算机上都有该程序.

这两个应用程序都应使用主机的ip地址进行连接.

关闭防火墙可能不是最好的方法.您需要确保主机上的端口是打开的，以便它可以接收到mysql服务器的连接.在mysql配置中更改绑定地址以侦听IP地址，而不是本地主机.

Mysql is a server itself, and listens on it''s own port. The apache part of wamp is not entirely important here, because you are not using HTTP to connect to it. The mysql website has instructions for installing on windows, as well as a .net connector that is very useful.

I assume that you have the mysql database on one computer, and the program on both.

Both applications should use the host computers ip address to connect.

Turning off the firewall is probably not the best approach. You need to make sure the port is open on the host computer so that it can recieve the connections to the mysql server. Change the bind address in the mysql configuration to listen on the ip address, not localhost.

这篇关于通过网络工作的Wamp服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！