進(jìn)行與mysql數(shù)據(jù)庫(kù)連接的時(shí)候出現(xiàn)錯(cuò)誤
#?獲取數(shù)據(jù)庫(kù)鏈接 conn?=?pymysql.connect(host='localhost', ??????????????????????user='root', ??????????????????????password='123456', ??????????????????????db='baike', ??????????????????????charset='utf8md4', ??????????????????????port=3306)
錯(cuò)誤：
Traceback?(most?recent?call?last): ??File?"E:/GC/imooc/MySQL.py",?line?31,?in?<module> ????port=3306) ??File?"C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\__init__.py",?line?90,?in?Connect ????return?Connection(*args,?**kwargs) ??File?"C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\connections.py",?line?659,?in?__init__ ????self.encoding?=?charset_by_name(self.charset).encoding AttributeError:?'NoneType'?object?has?no?attribute?'encoding'
嘗試多種方法仍然不能夠解決
2018-01-11
你要么寫charset='utf8'，要么寫charset='utf8mb4',而不是'utf8md4'。
2017-03-07
這個(gè)你得代碼展示的不完全，只看報(bào)錯(cuò)的話，應(yīng)該是你哪里用到了encoding，但是encoding的值是None導(dǎo)致的
2017-01-20
你確定這個(gè)數(shù)據(jù)庫(kù)你建立成功了??？