mysql禁用GTID

数据库导入老是出现

mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 3546 (HY000) at line 24: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED –> exit status 1

手动去改SQL很麻烦

直接sql执行

mysql -uroot -p
###输入密码
###执行以下即可，重新备份即可导入
mysql> SET @@GLOBAL.GTID_MODE = ON_PERMISSIVE;
Query OK, 0 rows affected (0.08 sec)

mysql> SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE;
Query OK, 0 rows affected (0.06 sec)

mysql> SELECT @@GLOBAL.GTID_OWNED;
+---------------------+
| @@GLOBAL.GTID_OWNED |
+---------------------+
|                     |
+---------------------+
1 row in set (0.00 sec)

mysql> SET @@GLOBAL.GTID_MODE = OFF;
Query OK, 0 rows affected (0.06 sec)