.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
– Engr, Commented Feb 1, 2018 at 5:55
Started in Services and its running too but getting the same error — Liyakhat Ali Sheikh
– Liyakhat Ali Sheikh, Commented Feb 1, 2018 at 5:59
ok try one more thing remove port number make it as jdbc:mysql://localhost/ — Engr
– Engr, Commented Feb 1, 2018 at 6:04
follow this i hope this helps, stackoverflow.com/questions/6865538/… — Engr
– Engr, Commented Feb 1, 2018 at 6:11

Peyman Mohamadpour · Accepted Answer · 2020-05-08 11:55:34Z

4

Try adding this to your connection String:

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

it worked for me

edited May 8, 2020 at 11:55

Peyman Mohamadpour

18k24 gold badges94 silver badges102 bronze badges

answered Apr 24, 2018 at 1:33

Artur Soares

745 bronze badges

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

1 Comment

Pedro Queiroga Over a year ago

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

Collectives™ on Stack Overflow

.MySQLNonTransientConnectionException: Could not create connection to database server

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related