RROR 1785 (HY000): Statement violates GTID consistency


I’ve setup percona operator xtradb, when I try to add user, I’ve this issue :

MySQL [mysql]> CREATE USER 'user'@'%' IDENTIFIED BY  '*7C4C5876A21D4';
ERROR 1785 (HY000): Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

any idea ? thanks

1 Like

Do you have autocommit turned off? Can you check the CREATE TABLE of the mysql.user table and ensure that it is InnoDB? Or did you run this command inside a transaction?