DataGrip connection to MariaDB gives Timeout

I want to use DataGrip to get more control over my data inside my database, and I have tried to SSH tunneling as described in: https://discord.com/channels/564160730845151244/1087377262640365728/1087399578401263677, but I can't get it to work. It keeps giving me the error SSH: Connection timed out: connect.. I have included the options inside the screenshots.

TL;DR

Developers faced timeout issues when connecting DataGrip to MariaDB. Adding port 3306 and changing connection to 'localhost' in the `docker-compose.yml` file resolved the problem. Ensure to enter the correct IP address in the main screen and when testing the SSH connection.

When clicking on test ssh connection What you get?

The IP should be of the server

The IP address of the SSH tunnel is the ip address I get when I run the docker network inspect.

So this IP should be in the main screen

Check this https://gist.github.com/byawitz/885510a4d9789e97424337e9472276d7

Here you need to enter your server public IP

Here you should enter the 172.18.0.4 IP

Alright, now it gives me this error:

Is your server IP is localhost? Is this a local instance or remote one?

I want to access my local instance indeed.

Local, as in your local machine? If so do this

Add these lines in your docker-compose.yml file

TypeScript

  mariadb:
    image: mariadb:10.11 # fix issues when upgrading using: mysql_upgrade -u root -p
    container_name: appwrite-mariadb
    <<: *x-logging
    restart: unless-stopped
    networks:
      - appwrite
    volumes:
      - appwrite-mariadb:/var/lib/mysql:rw
+   ports:
+    - 3306:3306
    environment:
      - MYSQL_ROOT_PASSWORD=${_APP_DB_ROOT_PASS}
      - MYSQL_DATABASE=${_APP_DB_SCHEMA}
      - MYSQL_USER=${_APP_DB_USER}
      - MYSQL_PASSWORD=${_APP_DB_PASS}
      - MARIADB_AUTO_UPGRADE=1
    command: 'mysqld --innodb-flush-method=fsync'