无法使用 Python 从 Docker 连接 MariaDB

Question

我正在尝试连接作为docker-compose服务运行的mariadb。我有一个名为"；应用程序"；并在其中包含一个新的python文件，用于连接数据库。

它成功地将连接到phpmyadmin，但当我尝试连接python时，由于某些原因失败：

错误消息：

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'mariadb:3306' (-3 Try again)

docker compose.yml

version: "3"
services:
app:
build:
context: .
dockerfile: ./Dockerfile
volumes:
- ./app:/app
command: >
sh -c "python3 services/db_connection.py"
depends_on:
- mariadb
prestashop:
image: prestashop/prestashop
networks:
myprestashop:
ports:
- 8181:80
links:
- mariadb:mariadb
depends_on:
- mariadb
volumes:
- /srv/Configs/PrestaShop/src:/var/www/html
- /srv/Configs/PrestaShop/src/modules:/var/www/html/modules
- /srv/Configs/PrestaShop/src/themes:/var/www/html/themes
- /srv/Configs/PrestaShop/src/override:/var/www/html/override
environment:
- PS_DEV_MODE=1
- DB_SERVER=mariadb
- DB_USER=root
- DB_PASSWD=mycustompassword
- DB_NAME=prestashop
- PS_INSTALL_AUTO=0
mariadb:
image: mariadb
networks:
myprestashop:
volumes:
- /srv/Databases/PrestaShop:/var/lib/mysql
environment:
- MYSQL_ROOT_PASSWORD=mycustompassword
- MYSQL_DATABASE=prestashop
phpmyadmin:
image: phpmyadmin/phpmyadmin
networks:
myprestashop:
links:
- mariadb:mariadb
ports:
- 1235:80
depends_on:
- mariadb
environment:
- PMA_HOST=mariadb
- PMA_USER=root
- PMA_PASSWORD=mycustompassword
networks:
myprestashop:

db_connection.py

import mysql.connector as database
connection = database.connect(
user='root',
password='mycustompassword',
host='mariadb',
database='prestashop')

if connection:
print ("Connected Successfully")
else:
print ("Connection Not Established")

感谢的帮助

Answer 1

您忘记将myprestashop网络添加到app服务中。如果一个服务没有任何明确定义的网络，它将使用default网络(它的名称类似于myproject_default(。因此，错误的原因是app服务在一个网络中，而其他所有服务都在另一个网络(myprestashop(中。