我的fucntions.py中有一个函数,该函数创建MySQL数据库,如果存在数据库,则连接到该数据库。效果很好。
class InvalidLoginError():
def __init__(self, message):
self.message = message
# Create mysql database
def createDB(username, password, db_name):
# URL for DB, username, password and DB name
# User has to send db username, pas
@classmethod
def getSwDataPass(self, uid, pw, dbname='swdata', _count=0):
result = None
if dbname == '':
dbname = input('Could not find a database by the name swdata. Please provide the database name : ')
if dbname == '' or dbname is None:
我在堆栈溢出和另一个编码示例站点中看到了本主题讨论的内容。但我找不到任何成熟的解决方案,有人修复这个错误吗?
错误信息:
ERROR:root:Can't connect to to MySQL server with error: (pymysql.err.InternalError) Packet sequence number wrong - got 1 expected 0
ERROR:root:Can't connect to to MySQL server with error: (pymysql.err.InternalError) Packet sequence
我在Python3.8中使用pymysql来允许Python连接到另一个MySQL服务器。我收到一个错误:
with pymysql.connect('127.0.0.1', user = '123', password = '123', port = server.local_bind_port) as connection:
AttributeError: __enter__
python:
from sshtunnel import SSHTunnelForwarder
import pymysql
我是Python新手,正在尝试创建一个通过PyMySQL将数据保存到DB的表单,但我在连接到DB时遇到了问题。我遵循了一个示例代码(我的版本在下面),并彻底检查了所有语法和语音标记,但仍然得到以下错误。
File "c:\Users\Nimrod\Nimrod Dropbox\Dropbox\Nimrodsky\Python\Adiabatic Equation\DB connect with PyMySQL.py", line 10, in <module> charset='utf8')
File "C:\ProgramData\Anac