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
Deleted user commented
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)
UserName011 commented
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