使用raspbian中的PyMSQL连接到MariaDB

2024-03-29 07:37:59 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试使用pymysql连接到flask项目中的mariaDB。
这是我的密码:

from flask import Flask
import pymysql.cursors

app = Flask(__name__)

try:
    connection = pymysql.connect(host='127.0.0.1',
                                 user='root',
                                 password='password',
                                 db='thesis',
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)
    print('all fine')

在raspberry pi上运行时,出现以下错误:

  File "app.py", line 12, in <module>
    cursorclass=pymysql.cursors.DictCursor)
  File "/usr/local/lib/python3.7/dist-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 327, in __init__
    self.connect()
  File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 597, in connect
    self._get_server_information()
  File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 966, in _get_server_information
    packet = self._read_packet()
  File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 670, in _read_packet
    % (packet_number, self._next_seq_id))
pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 0

我也不知道该怎么做在我的笔记本电脑里一切都很好,但是在树莓皮里面一切都是这样的!
无论如何,我的pymysql版本是0.9.2。你知道吗


Tags: inpyselfpacketlibpackagesusrlocal