python链接mysql拒绝访问_连接MySQL数据库的Python中的Keyerror 255错误,python,mysql,出现,keyerror255...

python 连接 mysql 数据库出现 keyerror： 255，字符集相关错误

Traceback (most recent call last):

File "", line 1, in

mydata = con_mysql(sql)

File "", line 3, in con_mysql

,port = port,db = dbname,charset="utf8")

File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\__init__.py", line 90, in Connect

return Connection(*args, **kwargs)

File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 706, in __init__

self.connect()

File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 931, in connect

self._get_server_information()

File "D:\Programfiles\Anaconda3\lib\site-packages\pymysql\connections.py", line 1269, in _get_server_information

self.server_charset = charset_by_id(lang).name

File "D:\Programfiles\An