Docker

Docker desktop is an environment to run docker containers locally: https://www.docker.com/products/docker-desktop/

Once you have docker desktop set up mysql:

docker run -p 13306:3306 --name mysql2 -eMYSQL_ROOT_PASSWORD=123456 -d mysql:latest

To get MySQL running in docker check this guide: https://hevodata.com/learn/docker-mysql/#s1

Check what you run:

docker ps

To list existing docker images

docker images

To manage mysql you can use MySQL Workbench: https://dev.mysql.com/downloads/workbench/

In mysql create a Schema called Db1 and in MDrivenServer set ConnectionType to MySQL and connection string to :

Server=127.0.0.1;port=13306;Database=Db1;Uid=root;Pwd=123456;

To create a docker image from a published .net app :

docker build -t mdriverserverimage -f Dockerfile .

Where the Dockerfile contains this:

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build-env
WORKDIR /App
# Copy everything
COPY . ./
WORKDIR .
EXPOSE 5000/tcp
ENTRYPOINT ["dotnet", "AppCompleteGenericCore.dll"]

When starting your web apps from visual studio set these settings to control port and use of http:

If you run your MDrivenServer from a docker container - and connect to a MySQL in another docker container then remember that normally must be on the same network to be allowed to talk. Also remember to use port and ip from THAT docker network and not your external.

Since docker starts a network called bridge you can find out your mysql ip on that network like this:

docker inspect <container_id>

Server=172.17.0.3;port=3306;Database=Db1;Uid=root;Pwd=123456;