MYSQL bench to connect to docker-compose db containers

MYSQL bench is visualization tool of db :

https://dev.mysql.com/downloads/workbench/

check out the MYSQL version it supports

older version of MYSQL workbench can be downloaded :

https://downloads.mysql.com/archives/workbench/

https://dev.mysql.com/doc/workbench/en/wb-intro.html#:~:text=MySQL%20Workbench%20fully%20supports%20MySQL,attempt%20to%20make%20a%20connection.

MySQL Workbench is a graphical tool for working with MySQL servers and databases. MySQL Workbench fully supports MySQL server version 5.7 and higher. Deprecated versions of MySQL Server (prior to version 5.7) are incompatible with MySQL Workbench and should be upgraded before you attempt to make a connection.

MYSQL workbench wont support  MYSQL 8.1.0

https://www.reddit.com/r/mysql/comments/15dzgac/mysql_workbench_not_compatible_with_mysql_810/

downgrade your Mysql server to 8.0.34

workaround(currently used)

I encounter the same message followed by a crash of MySQL Workbench, with version 6.3.7 (build 1199).

I didn't find a solution, but here is a work-around:

Once you press the button Continue anyway, just open a database use toto, and then wait a bit (a minute is enough in my case), and then you can call a query without a crash. I found this trick here.

Connection to docker

1. first database -> manage connections -> create a new one 

2.  connection method -> standard tcp/ip over ssh

3. specify ssh info to the remote server, private key needed if using public/private key method, 

4. then speicfy ur mysql ip and port, for docker-compose u should specify 127.0.0.1 it means its using your remote server's IP in 3,  then specify the port you used in docker-compose like 3333,

because docker uses different subnet, and maps your current host port to its subnet port, you can also find docker containers ip through docker ps, docker inspect <containerID> then u can use container IP 3306

  db:

    image: mysql:8

    environment:

....

    ports:

      - "3333:3306"