pymysql连接数据库时报错:AttributeError: ‘NoneType‘ object has no attribute ‘encoding‘

中午我在使用python3.8.10连接数据库时出现了这样的错误

代码

conn = pymysql.connect(host='127.0.0.1',
                       user='root',
                       port=3306,
                       password='81718922wu',
                       database='chatroom',
                       charset='utf-8')

报错

C:UsersAdministratorAppDataLocalProgramsPythonPython38python.exe C:/Users/Administrator/PycharmProjects/chatroom/chatroom/服务端/data.py
Traceback (most recent call last):
  File "C:/Users/Administrator/PycharmProjects/chatroom/chatroom/服务端/data.py", line 3, in 
    conn = pymysql.connect(host='127.0.0.1',
  File "C:UsersAdministratorAppDataLocalProgramsPythonPython38libsite-packagespymysqlconnections.py", line 311, in __init__
    self.encoding = charset_by_name(self.charset).encoding
AttributeError: 'NoneType' object has no attribute 'encoding'

看到了encoding,我机智的去掉了utf-8中的-,没想到就成功了.

可是事实上utf-8这种写法也行,报错应该是pymysql自身的缘故