pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '172.16.1.234' ([Errno 111] Connection refused)")

[shukuinfo]

你好，一直提示无法连接数据库，但数据库是可以正常连接的，是什么原因呢 [root@node234 reverse_sql-reverse_sql_progress]# ./reverse_sql.py -ot test -op delete -H 172.16.1.234 -P 3336 -u root -p Rscpass123. -d test --binlog-file mysql-bin.000062 --start-time "2024-01-25 14:44:46" --end-time "2024-01-25 14:45:06" Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 916, in connect **kwargs) File "/usr/lib64/python3.6/socket.py", line 724, in create_connection raise err File "/usr/lib64/python3.6/socket.py", line 713, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "./reverse_sql.py", line 368, in mysql_charset=args.mysql_charset File "./reverse_sql.py", line 40, in check_binlog_settings conn = pymysql.connect(*source_mysql_settings) File "/usr/local/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect return Connection(args, **kwargs) File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 706, in init self.connect() File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 963, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '172.16.1.234' ([Errno 111] Connection refused)")

[shukuinfo]

[root@node234 reverse_sql-reverse_sql_progress]# pip list Package Version

---

mysql-replication 0.13 pip 21.3.1 PyMySQL 0.7.11 pytz 2023.3.post1 setuptools 39.2.0 wheel 0.29.0

[shukuinfo]

[root@node234 reverse_sql-reverse_sql_progress]# python --version Python 3.6.2 [root@node234 reverse_sql-reverse_sql_progress]#

[hcymysql]

检查一下root账号，默认是不能远程连接的。创建一个新的账号admin@'%'(具备远程连接)