Hi, I started a Prisma server with MySQL in local ...
# orm-helpj
Josef Henryson
09/09/2019, 2:34 PMHi, 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:
Copy code
$ docker port prisma-test_mysql_1 3306
Error: No public port '3306/tcp' published for prisma-test_mysql_1d
divyendu
09/09/2019, 2:41 PMPlease share your
docker-composedivyendu
09/09/2019, 2:42 PMIf 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
j
Josef Henryson
09/09/2019, 2:42 PM Copy code
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: ~d
divyendu
09/09/2019, 2:44 PMYou can add a ports secttion to the mysql part
Copy code
mysql:
image: mysql:5.7
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: prisma
volumes:
- mysql:/var/lib/mysqldivyendu
09/09/2019, 2:44 PMThen do a
docker-compose up -dj
Josef Henryson
09/09/2019, 2:46 PMok, and the which IP should I use to connect?
Is it the docker 192.168.99.100 or the container IP?
d
divyendu
09/09/2019, 2:47 PMlocalhost: 3306 after this should work..
ports from docker essentially maps a docker port to localhost port
j
Josef Henryson
09/09/2019, 2:47 PMwow, that’s awesome, it works! Thank you! 🙏🏼
👍 1
d
divyendu
09/09/2019, 3:00 PM63 Views