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?

1 Like

No for autocommit, I don’t know why but when I add WITH mysql_native_password to CREATE USER, it’s ok. thanks @matthewb

1 Like