MySql with JAVA error The last packet sent successfully to the server was 0 milliseconds ago

Question

I have read about this exception a lot  but I can t solve my   Mysql server is working    I can connect to it from NetBeans  but I can t connect to it from java code   Exception in thread  main  com mysql jdbc exceptions jdbc4 CommunicationsException  Communications link failure  The last packet sent successfully to the server was 0 milliseconds ago  The driver has not received any packets from the server      at sun reflect NativeConstructorAccessorImpl newInstance0 Native Method      at sun reflect NativeConstructorAccessorImpl newInstance NativeConstructorAccessorImpl java 57      at sun reflect DelegatingConstructorAccessorImpl newInstance DelegatingConstructorAccessorImpl java 45      at java lang reflect Constructor newInstance Constructor java 525      at com mysql jdbc Util handleNewInstance Util java 411      at com mysql jdbc SQLError createCommunicationsException SQLError java 1116      at com mysql jdbc MysqlIO  lt init gt  MysqlIO java 344      at com mysql jdbc ConnectionImpl coreConnect ConnectionImpl java 2332      at com mysql jdbc ConnectionImpl connectOneTryOnly ConnectionImpl java 2369      at com mysql jdbc ConnectionImpl createNewIO ConnectionImpl java 2153      at com mysql jdbc ConnectionImpl  lt init gt  ConnectionImpl java 792      at com mysql jdbc JDBC4Connection  lt init gt  JDBC4Connection java 47      at sun reflect NativeConstructorAccessorImpl newInstance0 Native Method      at sun reflect NativeConstructorAccessorImpl newInstance NativeConstructorAccessorImpl java 57      at sun reflect DelegatingConstructorAccessorImpl newInstance DelegatingConstructorAccessorImpl java 45      at java lang reflect Constructor newInstance Constructor java 525      at com mysql jdbc Util handleNewInstance Util java 411      at com mysql jdbc ConnectionImpl getInstance ConnectionImpl java 381      at com mysql jdbc NonRegisteringDriver connect NonRegisteringDriver java 305      at java sql DriverManager getConnection DriverManager java 579      at java sql DriverManager getConnection DriverManager java 243      at javaapplication3 JavaApplication3 main JavaApplication3 java 32  Caused by  java net SocketException  Permission denied  connect     at java net DualStackPlainSocketImpl connect0 Native Method      at java net DualStackPlainSocketImpl socketConnect DualStackPlainSocketImpl java 69      at java net AbstractPlainSocketImpl doConnect AbstractPlainSocketImpl java 339      at java net AbstractPlainSocketImpl connectToAddress AbstractPlainSocketImpl java 200      at java net AbstractPlainSocketImpl connect AbstractPlainSocketImpl java 182      at java net PlainSocketImpl connect PlainSocketImpl java 157      at java net SocksSocketImpl connect SocksSocketImpl java 391      at java net Socket connect Socket java 579      at java net Socket connect Socket java 528      at java net Socket  lt init gt  Socket java 425      at java net Socket  lt init gt  Socket java 241      at com mysql jdbc StandardSocketFactory connect StandardSocketFactory java 257      at com mysql jdbc MysqlIO  lt init gt  MysqlIO java 294          15 more Java Result  1   I catch this exception with any ways to connect to Mysql from java code  but from MysqlWorkBench and from NetBeans is OK  I have no Firewall  I tried 127 0 0 1  result is the same

User · Answer

It seems that your Java code is using IPv6 instead of IPv4. Please try to use 127.0.0.1 instead of localhost. Ex.: Your connection string should be

jdbc:mysql://127.0.0.1:3306/expeditor?zeroDateTimeBehavior=convertToNull&user=root&password=onelife

P.S.: Please update the URL connection string.

User · Answer

There are two things   Disable firewall if any or add exception or check if u have correct driver file  Disable any antivirus if any and also make sure your driver type is mysql jdbc driver

User · Answer

Try the following suggestions    Your machine may have a static IP  map this IP to the hosts file as localhost  Try to log in from your computer or within the network via mysql command  if login is successful  it means that MySQL runs fine

User · Answer

THis issue has been fixed with new mysql connectors  please use http   mvnrepository com artifact mysql mysql-connector-java 5 1 38  I used to get this error after updating the connector jar  issue resolved

User · Answer

Try to specify the port in    conn   DriverManager getConnection  jdbc mysql   localhost mysql                                              user root amp password onelife      I think you should have something like this    conn   DriverManager getConnection  jdbc mysql   localhost 3306 mysql                                                  user root amp password onelife      Also  the port number in my example  3306  is the default port  but you may change it while installing MySQL   I think that a better way to specify password and user is to separate them from the URL like this   connection   DriverManager getConnection url  login  password

User · Answer

The problem is mostly due to a MySQL service that is not running  so make sure it is  If it isn t  run this CMD with administrator privilege in order to start it   sc start  Your MySQL Service name

User · Answer

Search the file my cnf and comment the line  skip-networking   to   skip-networking   Restart mysql

[java] MySql with JAVA error. The last packet sent successfully to the server was 0 milliseconds ago

Examples related to java

Examples related to mysql

Examples related to mysql-connector