CODEWITHSUNDEEP
javamysqlwamp
user2222
user2222

Reputation: 21

Connect to the MySQL server from another PC (from java application)

I realized an java application that connects to MySQL.

when i make my ip adress of my pc in the navigator of another pc in same local network ,I access to phpMyadmin and Wamp.

When i make 127.0.0.1 on the same pc (Wamp install) I connect to 127.0.0.1 from my java application and it works .

but the problem when I put my ip address in my java application either from my pc or from another pc in same local network , I can not manage to connect .

this is my file of configuration in the java application:

db.user=root
db.password=
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://192.168.1.59:3306/testfournisseur

Is there a manipulation to do?

This is the errors appear when i connect to the database:

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:   Communications link failure

Last packet sent to the server was 1 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:666)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1069)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
... 72 more
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:590)
... 74 more

Upvotes: 0

Views: 1337

Answers (1)

Connor Spencer Harries
Connor Spencer Harries

Reputation: 878

I'm unfamiliar with MySQL on Windows but the most common reason I see for being unable to connect is that the bind-address in my.cnf is set to 127.0.0.1, if you change this to 0.0.0.0 or another accessible address then it should work fine.

I also noticed you specify port 80 in your properties example, MySQL runs on 3306 by default so changing the port to that (or omitting it) may work.

Edit: Windows' built-in firewall may be blocking the connection so it's definitely worth checking out.

Upvotes: 1

Related Questions