CODEWITHSUNDEEP
mysqldatagrip
Anton
Anton

Reputation: 161

Cannot connect to MySQL-Server with DataGrip

The MySQL-Server is running in a docker container, configured with docker-compose:

services:
  legacy_db:
    image: liupeng0518/mysql:5.7-arm64
    environment:
      MYSQL_ROOT_PASSWORD: symfony
      MYSQL_USER: symfony
      MYSQL_PASSWORD: symfony
      MYSQL_DATABASE: symfony
    command:
      - '--default-authentication-plugin=mysql_native_password'
      - '--sql_mode='
      - '--max_allowed_packet=1073741824'
    volumes:
      - legacy_db:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mysqladmin", "-u", "root", "-psymfony", "ping", "-h", "localhost"]
      timeout: 5s
      retries: 30
      interval: 1s
    ports:
      - '3307:3306'

Error in DataGrip Build #DB-241.17890.24:

The server has terminated the handshake. The protocol list option (`enabledTLSProtocols`) is set, this option might cause connection issues with some versions of MySQL. Consider removing the protocol list option in the JDBC driver.

What must be done to connect to the database?

Upvotes: 1

Views: 272

Answers (1)

Ar2r
Ar2r

Reputation: 138

In DataGrip open "Advanced" tab in your connection, find "useSSL" and set "False" value. It works for me.

Upvotes: 2

Related Questions