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

最新推荐文章于 2024-07-30 10:28:28 发布

水滴-waterdrop

最新推荐文章于 2024-07-30 10:28:28 发布

阅读量1.1k

点赞数 3

文章标签：数据库 python database

本文链接：https://blog.csdn.net/wu1643001598/article/details/125346383

版权

Python pymysql 数据库连接编码问题 utf-8

关键词由CSDN通过智能技术生成

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

代码

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

报错

C:\Users\Administrator\AppData\Local\Programs\Python\Python38\python.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 <module>
    conn = pymysql.connect(host='127.0.0.1',
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\pymysql\connections.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自身的缘故