How can i access my database present in the droplet from my spring jdbc properties

February 17, 2016 1k views
Java

HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

1 Answer

Assuming you are using MySQL you will need to adjust your configuration. By default the MySQL daemon only listens locally for connections. To reach your database from another computer (If this is what you are attempting) you will need to adjust the bind-address variable in /etc/mysql/my.cnf (assuming you are using Ubuntu). Setting this to 0.0.0.0 or commenting it out completely and restarting the MySQL service should allow you to connect.

Have another answer? Share your knowledge.