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

Posted February 17, 2016 3.4k views

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

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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 or commenting it out completely and restarting the MySQL service should allow you to connect.