用spyder库pymysql调用mysql数据库时出现的ProgrammingError: (1007, 'Unknown error 1007')如何解决？

Question

大一学生，

今天第一次使用pymysql

import pymysql
conn = pymysql.connect(host='localhost',user='root',passwd='*******',charset='utf8')
cursor = conn.cursor()
dbName='test' 
sql = 'show databases'
cursor.execute(sql)
dbs = cursor.fetchall()
for db in dbs:
    if dbName in db:
        cursor.execute('drop database '+dbName)
        break
    cursor.execute('create database ' +dbName)
conn.select_db(dbName)

用vscode调试到这里就运行不下去了

报错 ProgrammingError: (1007, 'Unknown error 1007')

有高手能帮帮忙吗？

Answer 1

cursor.execute('create database ' +dbName)

这个要放到else里面的