执行pymysql.connect时出现错误Keyerror 255 [英] Error Keyerror 255 when executing pymysql.connect
本文介绍了执行pymysql.connect时出现错误Keyerror 255的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是代码
import pymysql
pymysql.connect(
host='localhost',
port=3306,
user='root',
password='iDontWannaSay',
db='iDontWannaShow',
charset='utf8'
)
,错误回溯为:
data is :::::b'\xff\x02\x00\xff\x81\x15'....##### I was add near line 1279 which is print("data is :::::%s...."%data[i:i+6])
Traceback (most recent call last):
File "C:\Users\123\Desktop\pymysqldebug.py", line 8, in <module>
charset='utf8'
File "D:\Program Files (x86)\Python\Python35\lib\site-packages\pymysql\__init__.py", line 90, in Connect
return Connection(*args, **kwargs)
File "D:\Program Files (x86)\Python\Python35\lib\site-packages\pymysql\connections.py", line 709, in __init__
self.connect()
File "D:\Program Files (x86)\Python\Python35\lib\site-packages\pymysql\connections.py", line 934, in connect
self._get_server_information()
File "D:\Program Files (x86)\Python\Python35\lib\site-packages\pymysql\connections.py", line 1279, in _get_server_information
self.server_charset = charset_by_id(lang).name
File "D:\Program Files (x86)\Python\Python35\lib\site-packages\pymysql\charset.py", line 39, in by_id
return self._by_id[id]
KeyError: 255
好像struct.unpack方法将'\ xff \'解析为255并分配给self.server_language
一样,无论传递的非null字符集参数如何.
seems like struct.unpack method parse '\xff\' to 255 and assigned to self.server_language
, whatever the non-null charset argument passed.
这是MySQL版本问题吗?(版本8.0.1-dmr
)
Is this an MySQL version problem?(version 8.0.1-dmr
)
推荐答案
可以参考该问题 拉请求591
这篇关于执行pymysql.connect时出现错误Keyerror 255的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文