virtualenv python PyMySQL错误号99

Question

我下载了PyMySQL并尝试在virtualenv中使用它 通过绑定此代码。你知道吗

conn = pymysql.connect(host='localhost', user='root', passwd='123',
                       db='mysql', charset='utf8')

我一直在尝试不同类型的解决方案，例如将“localhost”更改为我的ipv4地址和127.0.0.1以及不同的端口号，并使用服务器绑定我的ipv4地址如下：

import socket
server = socket.socket() 
server.bind(("I typed my ipv4 address shown by ipconfig on cmd:)", 6677)) 
server.listen(4) 
client_socket, client_address = server.accept()
print(client_address, "has connected")
while 1==1:
    recvieved_data = client_socket.recv(1024)
    print(recvieved_data)

我发现我完全是一个初学者来解决这个问题，因为我不知道这个问题从何而来（无论是从尝试这样的解决方案）服务器绑定或者从控制室的声明中。 因此我决定寻求帮助。谢谢你阅读这篇文章。你知道吗

我特别遇到了这个错误消息。你知道吗

Traceback (most recent call last):
  File "/workspace/pythoninitiative/env/lib/python3.6/site-packages/pymysql/connections.py", line 583, in connect
    **kwargs)
  File "/usr/local/lib/python3.6/socket.py", line 724, in create_connection
    raise err
  File "/usr/local/lib/python3.6/socket.py", line 713, in create_connection
    sock.connect(sa)
OSError: [Errno 99] Cannot assign requested address

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/workspace/pythoninitiative/env/virtualindex", line 25, in <module>
    db='mysql', charset='utf8')
  File "/workspace/pythoninitiative/env/lib/python3.6/site-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/workspace/pythoninitiative/env/lib/python3.6/site-packages/pymysql/connections.py", line 325, in __init__
    self.connect()
  File "/workspace/pythoninitiative/env/lib/python3.6/site-packages/pymysql/connections.py", line 630, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested