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.

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

  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'

Then, run

docker compose up -d

Then, change the connection to localhost, remove the SSH tunnel and you're set to go

Yes, it works now. Thanks for the help!

:appwritefire: