问题记录-python连接远程主机redis数据库时无法成功连接

虚拟机图形界面解决办法

设置centos上的redis可以被访问 - pyhui的python全栈技术博客 - CSDN博客
https://blog.csdn.net/ifubing/article/details/101477751

云主机ECS解决办法

修改配置中的bind 让它为0.0.0.0

然后使用公网ip来连接redis数据库

就可正常

以下是正文。。。。。。。。。。。。。。。。

代码

报错

C:\ProgramData\Anaconda3\python.exe G:/dailyfresh/a0test/two.py
Redis<ConnectionPool<Connection<host=172.16.212.104,port=6379,db=0>>>
Traceback (most recent call last):
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\connection.py", line 538, in connect
    sock = self._connect()
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\connection.py", line 595, in _connect
    raise err
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\connection.py", line 583, in _connect
    sock.connect(socket_address)
TimeoutError: [WinError 10060] 由于连接方在一段时间后没有正确答复或连接的主机没有反应，连接尝试失败。

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "G:/dailyfresh/a0test/two.py", line 7, in <module>
    res = sr.set("name", "zgl")
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\client.py", line 1519, in set
    return self.execute_command('SET', *pieces)
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\client.py", line 836, in execute_command
    conn = self.connection or pool.get_connection(command_name, **options)
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\connection.py", line 1071, in get_connection
    connection.connect()
  File "C:\ProgramData\Anaconda3\lib\site-packages\redis\connection.py", line 543, in connect
    raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 10060 connecting to 172.16.212.104:6379. 由于连接方在一段时间后没有正确答复或连接的主机没有反应，连接尝试失败。.

Process finished with exit code 1

原因分析

远程主机的安全防护，阻止了远程计算机，即本地电脑的访问

解决办法编写中。。。