DBeaver

DBeaver is a multiple DBMS client included among other MySQL. Download: https://dbeaver.io/download/

Database > Driver Manager

Find MySQL

Database > New Database Connection

Select MySQL

Change the allowPublicKeyRetrieval parameter to false

In this example you are going to connect to a MySQL DBMS that is inside a Docker container. Here the important thing is the IP, user and password.

New SQL script to write SQL statements

Try running the following command using the play button