farcepest/MySQLdb1

Throwing "Commands out of sync; you can't run this command now" when executing multiple grant statement in MySQL 5.7

Opened this issue · 1 comments

import MySQLdb as db
cnn = db.connect()
cur = cnn.cursor()
SQL = """
grant select on *.* to test@'localhost' identified by '';
grant select on *.* to test2@'localhost' identified by '';
"""
cur.execute(SQL)

You have this problem apparently because both statements are executing simultaneously.
https://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html