在Windows机器上无法使用sqlalchemy连接到本地mysql数据库

代码sqlalchemy：

engine = create_engine('mysql+mysqldb://root:mypass@localhost/classicmodels')
engine.connect()

给出错误：

OperationalError: (_mysql_exceptions.OperationalError) (1193,"Unknown system variable 'tx_isolation'")

工作代码,使用pymysql：

connection = pymysql.connect(host='localhost',user='root',password = 'mypass',db = 'classicmodels')

cursor = connection.cursor()

cursor.execute('select * from customers')
mydata = cursor.fetchall()
mydata = pd.DataFrame(list(mydata))
mydata.head(5)