Run a mysql really quick in a docker container (cmd)

_run_mysql_in_docker.cmd

docker network create -d bridge internal-network

docker pull mysql
docker run --network=internal-network -p 3306:3306 --name mysql-db -e MYSQL_ROOT_PASSWORD=root -e MYSQL_ROOT_HOST=% -d mysql

If you compose your other containers with this option in the docker-compose.override.yml or docker-compose.yml file:

networks:
    default:
        external: true
        name: internal-network

Your connection string from within another docker container (which accesses the db from this new container) will be:

"Server=host.docker.internal;Port=3306;Database=mysql-db;Uid=root;Pwd=root;"

Your connection string from "outside" aka the host machine (with MySql Workbench) will be:

"Server=127.0.0.1;Port=3306;Database=mysql-db;Uid=root;Pwd=root;"

You can use MySql Workbench from your host machine to inspect your db or use a shell to create a new database:

1. Open a CLI-Session for the mysql-db container
2. run mysql -p
3. run create database mysql-db;