[Docker MySQL] com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago.

 

com.mysql.cj.jdbc.exceptions.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 com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.30.jar:8.0.30]

 

❗️ 원인

1. useSSL=false로 설정하고 allowPublicKeyRetrieval 설정을 하지 않은 경우입니다.

 

💡 해결방법 : https://tira-0.tistory.com/217

[MySQL] java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

 

 

 

2. MySQL user의 외부접속 허용을 하지 않은 경우 입니다.

 

💡해결방법 : https://tira-0.tistory.com/221

[Docker Mac] MySQL Community Server container 실행하기