Unable to connect to mysql in another machine docker

both machines use docker.
one is a dedicated web server, and the ip is 192.168.0.100, with a route 172.17.0. Universe 16 pointing to 192.168.0.130. The
docker network segment is 172.19.0.0Universe 16. Ip:172.19.0.2 of enabled docker-web

the other one acts as a database server. The ip is 192.168.0.130, with a route 172.19.0. 0. Universe 16 pointing to 192.168.0.100. The
docker network segment is 172.17.0.0Universe 16. Ip:172.17.0.2 of enabled docker-mysql

from the 192.168.0.100 web server, the direct connection to docker-mysql, was successful, and the ping enabled docker-mysql gateway 172.17.0.1
then came the problem: docker-web 172.19.0.2 enabled from 192.168.0.100 could not connect to docker-mysql 172.17.0.2

Gateway can be reached, but docker-mysql, cannot be reached. This should be because there is no default route in docker-mysql. Then I checked

docker inspect mysql 
    "IPAddress": "172.17.0.2",
    "Gateway": "172.17.0.1"

this is a little confusing. May I ask why?

Mysql docker

Mar.23,2021

suddenly finds himself a little dazed. The mysql port image started in docker points to the server, so you only need to access the port of 192.168.0.130 database server

Previous: The same HTML tag, different terminals, different situations, who to throw this pot to?

Next: Is to group the same attribute values and add different styles to ask for help.

Use docker to create a container based on the official image ubuntu 16.04.3, which cannot be started normally after installing mysql server
after initialization of the container, there is no problem with installing mysql-server and starting it for the first time, but when I exit the container and enter again, I will not be able to start mysql-server normally the following error was return...

Mysql docker

Mar.03,2021
The docker-compose mysql volumes directory mount problem caused the container to fail to start!
it s OK to mount the directory directly through the command line run-v, but I have a problem when I mount the directory through compose volumes. Other nginx redis mount directory files are normal, but mysql is not successful. I can mount the my.cnf con...

Mysql docker-compose docker

Jul.19,2021
Docker mysql failed to start
error log 2018-11-01T07:51:55.214905Z 0 [Warning] ERROR_FOR_DIVISION_BY_ZERO mode is removed. Setting this will have no effect. 2018-11-01T07:51:55.215499Z 0 [Warning] ERROR_FOR_DIVISION_BY_ZERO mode is removed. Setting this will have no effect...

Mysql docker

Oct.12,2021
Docker mysql startup container initialization error-initialize
everything is fine when I install Docker for Windows on Win10. Deploying your own .NET CORE application is also OK. but I can also pull MYSQL5.7 to execute the docker run command successfully, but prompt initialize specified but the data directory has f...

Mysql docker

Oct.27,2021
The container hangs after docker installs MySQL, and executes optimize
problem description I installed the general operation of MySQL, with docker, but when I deleted part of the data to optimize storage, after executing the optimize command, the container closed unexpectedly. I tried it twice and encountered the same si...

Mysql docker

Dec.24,2021
IPV6 visits the website, but the console mistakenly reports that the illegal URL, how to solve
problem description We have changed IPV4 to IPV6 network packet protocol, but when we visit, we say that URL is illegal, because IPV6 access is a http: [222:222:222:22]:80 index.html, expanded in square brackets like this. the environmental backgr...

Git mysql docker tornado javascript

May.25,2022
Docker for windows uses windows container to start mysql:latest error reporting
docker for windows uses windows container to start mysql:latest error and switch to linux container to start normally. start command: docker run-- name mysql_01-e MYSQL_ROOT_PASSWORD=root-d mysql docker log: ...

Mysql docker

Jun.21,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b37729-2b3fa.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b37729-2b3fa.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?