- 使用pymysql连接MySQL会报1366错
app.config['SQLALCHEMY_DATABASE_URI']="mysql+pymysql://root:123456@localhost:3306/blog"
错误提示:
* Restarting with stat C:\Users\Administrator\AppData\Roaming\Python\Python36\site-packages\pymysql\cursors.py:170: Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 480") result = self._query(query)
-
解决办法
- 在settings的项目环境中下载mysql-connector-python ,并安装;
- 下载并安装后将原来连接代码中的pymysql改成mysqlconnector
app.config['SQLALCHEMY_DATABASE_URI']="mysql+mysqlmysqlconnector://root:123456@localhost:3306/blog"
3.再次运行,就不会报错了。问题完美解决。