mysql报错1517_请教一下 flask+sqlalchemy+mysql 连接错误问题

在本地调试 docker-compose 调试 mysql+nginx+flask 程序，报错(2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")。

线索如下：

Flask app 运行地址: 0.0.0.0:5000

已将 mysql.cnf 中的bind-address改为0.0.0.0，并在容器里面确认过更改成功

使用 MySQLWorkbench 可以成功连接到 localhost 数据库

SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:[email protected]:3306/my_database?charset=utf8'

期待回复，非常感谢！

完整的错误日志：

webapp_1 | The above exception was the direct cause of the following exception:

webapp_1 |

webapp_1 | Traceback (most recent call last):

webapp_1 | File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 135, in handle

webapp_1 | self.handle_request(listener, req, client, addr)

webapp_1 | File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/sync.py", line 176, in handle_request

webapp_1 | respiter = self.wsgi(environ, resp.start_response)

webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1997, in __call__

webapp_1 | return self.wsgi_app(environ, start_response)

webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app

webapp_1 | response = self.handle_exception(e)

webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception

webapp_1 | reraise(exc_type, exc_value, tb)

webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise

webapp_1 | raise value

webapp_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app

webapp