连接数据库报错

[zouzhenglu]

在运行 sh /data/stock/jobs/cron.daily/run_daily的时候报错，连接数据库失败，不明白的是127.0.0.1后面的111是什么意思。 如果是端口错误，那么哪里能修改端口？我的mysql端口是3306

pythonstock 0.0.0.0:8888->8888/tcp, 0.0.0.0:9999->9999/tcp
mysql:5.7 0.0.0.0:3306->3306/tcp, 33060/tcp

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

Traceback (most recent call last): File "/data/stock/libs/common.py", line 171, in run_with_args run_fun(tmp_datetime_show) # 使用当前时间 File "/data/stock/jobs/guess_indicators_daily_job.py", line 75, in stat_all_lite_sell data = pd.read_sql(sql=sql_1, con=common.engine(), params=[datetime_int]) File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 634, in read_sql chunksize=chunksize, File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 1579, in read_query result = self.execute(args) File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 1424, in execute return self.connectable.execution_options().execute(args, kwargs) File "", line 2, in execute File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/deprecations.py", line 401, in warned return fn(*args, *kwargs) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3145, in execute connection = self.connect(close_with_result=True) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3204, in connect return self._connection_cls(self, close_with_result=close_with_result) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 96, in init else engine.raw_connection() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3283, in raw_connection return self._wrap_pool_connect(self.pool.connect, _connection) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3254, in _wrap_pool_connect e, dialect, self File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2101, in _handle_dbapi_exception_noconnection sqlalchemy_exception, with_traceback=excinfo[2], from=e File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3250, in _wrap_pool_connect return fn() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 310, in connect return _ConnectionFairy._checkout(self) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 476, in checkout rec = pool._do_get() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get self._dec_overflow() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in exit with_traceback=exctb, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 207, in raise raise exception File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get return self._create_connection() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection return _ConnectionRecord(self) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 371, in init self.connect() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 666, in connect pool.logger.debug("Error on connect(): %s", e) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in exit with_traceback=exctb, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 207, in raise raise exception File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 590, in connect return dialect.connect(cargs, cparams) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 597, in connect return self.dbapi.connect(*cargs, cparams) File "/usr/local/lib/python3.7/site-packages/MySQLdb/init.py", line 123, in Connect return Connection(*args, *kwargs) File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 185, in init super().init(args, kwargs2) sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can\'t connect to MySQL server on \'127.0.0.1\' (111 "Connection refused")') (Background on this error at: https://sqlalche.me/e/14/e3q8) rm -f /data/cache/hist_data_cache/2022-07/`