主机可以连接mysql容器不能_Mariadb docker容器无法用Python连接到主机上的MySQL服务器（111连接被拒绝）(Mariadb docker container Can't co...

Mariadb docker容器无法用Python连接到主机上的MySQL服务器(111连接被拒绝)(Mariadb docker container Can't connect to MySQL server on host (111 Connection refused) with Python)

我正在尝试使用docker-compose与python连接mariadb：

泊坞窗，compose.yml

version: '2'

services:

mariadb:

image: bitnami/mariadb

ports:

- "3306:3306"

environment:

MARIADB_DATABASE: 'mary_db'

MARIADB_USER: user2

MARIADB_PASSWORD: 'pass1234'

consumer:

build: ./consumer

links:

- mariadb

consumer.py

import mysql.connector as mariadb1

mariadb_connection = mariadb1.connect(host='mariadb',

port=3306,

user='user2',

password='pass1234',

database='mary_db')

cursor = mariadb_connection.cursor(buffered=True)

try:

cursor.execute('DROP TABLE names')

except:

pass

comm = "CREATE TABLE names(id VARCHAR(20), location VARCHAR(100)," \

"PRIMARY KEY (mac,location)) ENGINE=InnoDB"

cursor.execute(comm)

print 'created'

Dockerfile入口点只是调用consumer.py函数，如：

ENTRYPOINT python -u consumer.py

该问题非常随机(超过90％的试验)，python代码无法连接数据库并输出此错误：

文件“consumer.py”，第7行，在database ='mary_db')文件“/usr/local/lib/python2.7/dist-packages/mysql/connector/init.py”，第179行，在连接返回MySQLConnection (* args，** kwargs)文件“/usr/l