使用sshtunnelforwarder连接远程mysql数据库时发生连接错误

kupeojn6  于 2021-06-24  发布在  Mysql
关注(0)|答案(0)|浏览(354)

我正在尝试使用sshtunnel连接远程mysql数据库,但出现以下错误:

  1. mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'WWW.XXX.YYY.ZZ' (10061)

我在stackoverflow/其他站点中尝试了旧查询的可能解决方案,但没有任何效果。
脚本:

  1. import mysql.connector as myCon
  2. import sshtunnel
  3. server = sshtunnel.SSHTunnelForwarder(
  4. ('WWW.XXX.YYY.ZZ', 22),
  5. ssh_username='dbuser',
  6. ssh_password='dbuser',
  7. remote_bind_address=('WWW.XXX.YYY.ZZ', 3306)
  8. )
  9. server.start()
  10. connection = myCon.connect(host='WWW.XXX.YYY.ZZ', port=server.local_bind_port, user='demo', password='demo', database='ADC_test')

请帮助下面的错误
错误:

  1. Traceback (most recent call last):
  2. File "C:\Python36\lib\site-packages\mysql\connector\connection_cext.py", line 176, in _open_connection
  3. self._cmysql.connect(**cnx_kwargs)
  4. _mysql_connector.MySQLInterfaceError: Can't connect to MySQL server on 'WWW.XXX.YYY.ZZ' (10061)
  5. During handling of the above exception, another exception occurred:
  6. Traceback (most recent call last):
  7. File "D:\Sunil_Work\psnl\python\pyCharm\PyMySQL\Connect to MYSQL.py", line 14, in <module>
  8. connection = myCon.connect(host='WWW.XXX.YYY.ZZ', port=server.local_bind_port, user='demo', password='demo', database='ADC_test')
  9. File "C:\Python36\lib\site-packages\mysql\connector\__init__.py", line 182, in connect
  10. return CMySQLConnection(*args,**kwargs)
  11. File "C:\Python36\lib\site-packages\mysql\connector\connection_cext.py", line 78, in __init__
  12. self.connect(**kwargs)
  13. File "C:\Python36\lib\site-packages\mysql\connector\abstracts.py", line 736, in connect
  14. self._open_connection()
  15. File "C:\Python36\lib\site-packages\mysql\connector\connection_cext.py", line 179, in _open_connection
  16. sqlstate=exc.sqlstate)
  17. mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'WWW.XXX.YYY.ZZ' (10061)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题