How to access mysql dabasase on lan using java

Question

I have a a PC whose IP address is 192.168.0.101 and mysql port is 4000. When i try to connect to connect to it, it works fine but when i use another PC on the the same LAN whose IP address is 192.168.0.107, i keep on getting this exception:

Communication link failure due to underlying exception:
**BEGIN NESTED EXCEPTION**

java.net.ConnectionException
MESSAGE: connection timed out......

I have read so many posts like How to make mySQL database at my local accessible from different machines? but cant find my.cnf file. I also went through this Connecting to MySQL Database over server but still things are not working. All the computers on the lan are windows 7 x86. Please help me sort out this. Regards...

Most likely it isn't even going over the network when it accesses MySQL the same machine. — Tim Biegeleisen, Sep 27 '16 at 04:39
you can ping ip 192.168.0.107, if it time out, you should contact to system team to config it — Numb, Sep 27 '16 at 04:43
are you on DHCP? Meaning, a second box at `.107` ... probably a dumb question as it wouldn't be the one with the open socket — Drew, Sep 27 '16 at 04:47
@ScaryWombat, how about the firewall thing? how do i go about it? — Wafula Samuel, Sep 27 '16 at 04:55
Enter the command `netstat -nat|grep 4000` on the MySQL server to see if MySQL is listening on that port and what the bind address is. If it's not `0.0.0.0` then you need to change the `bind-address` parameter to it's listening for remote connections. — Jim Garrison, Sep 27 '16 at 05:35

score 0 · Answer 1 · answered Sep 27 '16 at 05:39

0

Look this page for example java Connect

answered Sep 27 '16 at 05:39

momomorez

515
5
5

How to access mysql dabasase on lan using java

1 Answers1