-2

I have two computers with IP addresses of 192.168.1.1 and 192.168.1.2 respectively. Both computers have Apache servers installed on them and both are listening to port 8080 rather than 80. I have connected both computers via LAN and I am successful in pinging each other.

However, I am unable to access, for example, MySQL database of one computer on the other via the LAN.

What are the required settings that should be altered??

Improve this question
4
  • Please clarify ... I am unable to access localhost of one computer on the other. Not sure what this even means. What are you trying to access and how?
    – jeffatrackaid
    Jan 4, 2012 at 17:28
  • @jeffatrackaid Please see the updated question. Does it helps now??
    – Rafay
    Jan 4, 2012 at 17:31
  • 1
    Check your firewall settings. Just realized this is a windows server, so that is a bit out of my expertise.
    – jeffatrackaid
    Jan 4, 2012 at 18:29
  • @jeffatrackaid Well now I am able to access the wamp main page through another computer. Now I want to work from MySQL's console from 192.168.1.1 into the databases stored on 192.168.1.2. Is this possible?? Please help me in this regard.
    – Rafay
    Jan 4, 2012 at 18:41

2 Answers 2

Reset to default
2

There are several possibilities, depending on details about what you want to achieve. You need to go through a troubleshooting process to establish where the error is. Assuming that you have some webapp on apache that is attempting to reach mysql on the other machine, here are a few to check to get you going:

  • Is mysql running?
  • Is mysql configured to listen to TCP sockets?
  • Is mysql listening on the external IP address?
  • Is mysql authentication/authorisation configured correctly? (in other words, have you created a database/user, granted privileges and is your client offering the correct credentials?)
  • Are there any firewalls between client & server?
  • Is the webserver/webapp configured correctly?

You might want to consider connecting to the mysql server from the other machine using a command line mysql client, instead of the webapp, in order to help reduce complexities and to help show where the failure is occurring.

Improve this answer
0

You can achieve this by installing phpmyadmin manually (preferably in c:) on both PCs and assign an Alias in httpd.conf file of your phpmyadmin installation. You can then access mySql through phpmyadmin using the browser. That's it.

Improve this answer

Not the answer you're looking for? Browse other questions tagged .