Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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??

share|improve this question

closed as too broad by Tom O'Connor Aug 14 '13 at 21:07

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

    
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 '12 at 17:28
    
@jeffatrackaid Please see the updated question. Does it helps now?? –  Mohammad Rafay Aleem Jan 4 '12 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 '12 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. –  Mohammad Rafay Aleem Jan 4 '12 at 18:41

2 Answers 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.

share|improve this answer

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.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.