java - 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.

Answer 1

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.