Wamp server that works over a network

Question

1.00/5 (1 vote)

See more:

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>

Posted 15-Jan-12 12:03pm

chieto

Add a Solution

Comments

Sergey Alexandrovich Kryukov 15-Jan-12 20:23pm

Why would you access database from both computers? You can do it but why? What is the role of both? Which one should act as a service, what kind and why. Which one should run HTTP server? Which computer and process should act as a client of one of more services?

If you are able to answer this questions by yourself, you will be able to understand the problem better. If you are able to understand the problem better, you will be able to explain it properly. When and if you are ready, use "improve question" above.

Thank you.
--SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

loctrice · Answer 1 · 2012-01-15T16:45:00

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.