Connect to MySQL with JDBC over network

Question

I am trying to connect to MySQL database over a network. I have installed MySQL, and the service is running on the default port. I have also install the SQL connector to the jar file and added java JDK to the server machine. I am able to connect to my local database using the code:

private String dbUrl = "jdbc:mysql://localhost/DatabaseName";
private String dbClass = "com.mysql.jdbc.Driver";

But when I try and connect to it over the network, with the IP address (eg: 192.168.1.45):

private String dbUrl = "jdbc:mysql://192.168.1.45/DatabaseName";
private String dbClass = "com.mysql.jdbc.Driver";

I get the connection error:

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

Does anyone know what this issue is? Do I need to add a different address? I have added the default port with the address but cannot get it to work.

Thanks for any help.

forums.mysql.com/read.php?39,199085,204628#msg-204628

zengr
– zengr

2010-11-25 12:23:35 +00:00
Commented Nov 25, 2010 at 12:23 — zengr
– zengr, Commented Nov 25, 2010 at 12:23

ccheneson · Accepted Answer · 2010-11-25 12:24:07Z

3

By default, MySQL doesnt allow remote access and only allow local access. You will have to modify your /etc/mysql/my.cnf config (on Linux) with:

bind-address = 192.168.1.45 // Your Server IP address
# skip-networking // This should be commented .

See the whole procedure here.

answered Nov 25, 2010 at 12:24

ccheneson

49.4k8 gold badges65 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

stacker · Accepted Answer · 2010-11-25 12:23:26Z

2

Check the my.cnf [mysqld] settings for the parameters port, bind-address, socket, to make sure these aren't causing problems.
Check the files /etc/hosts, /etc/hosts.deny to make sure everything is ok.
Check firewall applications
Check to make sure whatever directory mysqld's sockets are have the appropriate permissions.
Check to make sure that security settings within the mysql database (user table) permit access from your remote host.
Make sure you can telnet OK to localhost 3306, 127.0.0.1 3306, and whatever other IP address your machine is configured to (use ifconfig to find out).

answered Nov 25, 2010 at 12:23

stacker

69.1k29 gold badges143 silver badges214 bronze badges

Comments

Joshua Martell · Accepted Answer · 2010-11-25 16:19:03Z

0

You can test the server setup using the MySQL Workbench or mysql client which will narrow down the problem. It's also sometimes useful to just see if the server's there:

telnet host 3306

It'll tell you the version number of the server and some other binary junk. Enough to know your host is listening.

answered Nov 25, 2010 at 16:19

Joshua Martell

7,2122 gold badges33 silver badges37 bronze badges

Collectives™ on Stack Overflow

Connect to MySQL with JDBC over network

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related