mysql导入数据库报错：ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_

问题：ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

解决：

1、登入数据库执行reset master----无效

2、修改导入的文件：----生效

注释掉这一行：SET @@GLOBAL.GTID_PURGED=

/*SET @@GLOBAL.GTID_PURGED=XXXX*/;

执行步骤1后仍报错，执行步骤2可正常导入：

mysql -u账号 -h serverIp -P 3306 -p密码 库名 < *.sql