Hi I started a Prisma server with MySQL in local docker from

Question

Hi I started a Prisma server with MySQL in local docker from a tutorial I would like to be able to look into MySQL database with Sequel Pro but it fails to connect It seems like the port is not public available in the host ```$ docker port prisma test mysql 1 3306 Error No public port 3306 tcp published for prisma test mysql 1``` Any ideas how I can do this

divyendu · Answer

Please share your `docker compose` file

divyendu · Answer

If you used Prisma init there should be a commented part of code in docker compose that mentions on how you can expose it for external clients I can help you add it if you are able to share your docker compose file with me

Josef Henryson · Answer

```version 3 services prisma image prismagraphql prisma 1 34 restart always ports 4466 4466 environment PRISMA CONFIG | managementApiSecret 504b299af5e06294c426f858c39ff15b24297ee18e7e98abde0255d70c2cabdb port 4466 databases default connector mysql host mysql port 3306 user root password prisma mysql image mysql 5 7 restart always environment MYSQL ROOT PASSWORD prisma volumes mysql var lib mysql volumes mysql ~```

divyendu · Answer

You can add a ports secttion to the mysql part ``` mysql image mysql 5 7 restart always ports 3306 3306 environment MYSQL ROOT PASSWORD prisma volumes mysql var lib mysql ```

divyendu · Answer

Then do a `docker compose up d` in the same folder as the docker compose file

Josef Henryson · Answer

ok and the which IP should I use to connect Is it the docker 192 168 99 100 or the container IP

divyendu · Answer

localhost 3306 after this should work ports from docker essentially maps a docker port to localhost port

Josef Henryson · Answer

wow that s awesome it works Thank you pray skin tone 3

divyendu · Answer

<https docs docker com config containers container networking > slightly smiling face