.MySQLNonTransientConnectionException: Could not create connection to database server

Question

Getting Error For the Following Code

  package jdbcdrive;

import java.sql.*;
public class Lpt {

    /**
     * @param args
     * @throws SQLException
     */
    public static void main(String[] args) throws SQLException {

        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/lpt?autoReconnect=true&useSSL=false","root","2664");

        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery("SELECT * FROM sys.lpt");

        while(rs.next()) {

            System.out.println(rs.getInt("BatchName")+" "+rs.getString("StudentName")+" "+rs.getString("StudentName")+" "+rs.getString("studentMobileNo")+" "+rs.getString("Address"));
        }

    }

}

The Output Error I'm getting is

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

This issue mostly occured when mysql service is not started. start mysql service and start connection — Engr, Feb 01 '18 at 05:55
Started in Services and its running too but getting the same error — Liyakhat Ali Sheikh, Feb 01 '18 at 05:59
ok try one more thing remove port number make it as jdbc:mysql://localhost/ — Engr, Feb 01 '18 at 06:04
follow this i hope this helps, https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql — Engr, Feb 01 '18 at 06:11

score 4 · Accepted Answer · edited May 08 '20 at 11:55

4

Try adding this to your connection String:

"useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC"

it worked for me

edited May 08 '20 at 11:55

Peyman Mohamadpour

17,954
24
89
100

answered Apr 24 '18 at 01:33

Artur Soares

66
3

I already had my connection string (`spring.datasource.url`) quite close to that, except for the timezone which shouldn't matter. What solved it for me was to append `&createDatabaseIfNotExist=true` to the connection string! hope this helps someone – Pedro Queiroga Nov 03 '20 at 23:15

.MySQLNonTransientConnectionException: Could not create connection to database server

1 Answers1

Linked