Question Map Docker Container to plesk mysql localhost:3600

[Brandon Turpin]

How can I access my mysql server within plesk from within my docker container. I have an asp.net core website that I am trying to connect to a MYSQL database that is hosted outside the container. I try and connect within my container to localhost:3306 and get an error that there are no servers found.

Mapping does not work since I port 3306 is already being used. And I would need multiple containers to connect to the same port. I am at a lost what to do.

 

[Hex]

Your question isn't clear but..
If you want to use a MySQL managed by Docker on Plesk Server
You need to open a new port on your host ex. 3307 (also open that port if you have a cloud firewall)

Add a new container
Manual Mapping: 3306 to external 3307
Volume Mapping: /Var/lib/mysql to /var/docker/mysql

Add Environment Variable :
Name: MYSQL_ROOT_PASSWORD
Value: add your MySQL root password

and in adding DB server .. use 127.0.0.1 on port 3307 instead of localhost:3306

 

[Brandon Turpin]

Your question isn't clear but..
If you want to use a MySQL managed by Docker on Plesk Server
You need to open a new port on your host ex. 3307 (also open that port if you have a cloud firewall)

Add a new container
Manual Mapping: 3306 to external 3307
Volume Mapping: /Var/lib/mysql to /var/docker/mysql

Add Environment Variable :
Name: MYSQL_ROOT_PASSWORD
Value: add your MySQL root password

and in adding DB server .. use 127.0.0.1 on port 3307 instead of localhost:3306

Maybe I am doing something wrong. When I try and add a database server I get the following error

Host '172.17.0.1' is not allowed to connect to this MySQL server​

 

[Hex]

Question - How to connect installed database from Docker for customers?

 

[CharisM]

Hi there, hope it is ok to extend this talk? I have the same error on Plesk Obsidian with ubuntu 18.04 LTS (vServer) and i read a lot but i can't find why i do not get access to the mysql server within docker from plesk:



Would be great if anybody could give me a hint.

Many thanks!
c--