Setup MySQL with Docker on local environment and configure DBeaver connection.

Setup local MySQL (Docker).md

In the CLI pull MySQL image:

docker pull mysql/mysql-server:latest

docker run -d -p 3306:3306 
  --name your-container-name
  -e MYSQL_ROOT_PASSWORD=password 
  mysql/mysql-server:latest

Open the container terminal:

mysql -u root -p
CREATE USER 'yourUser'@'172.17.0.1' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'yourUser'@'172.17.0.1' WITH GRANT OPTION;
flush privileges;
CREATE DATABASE yourDatabase;
exit

Setup DBeaver URL

jdbc:mysql://host.docker.internal:3306/yourDatabase?allowPublicKeyRetrieval=true&useSSL=false