mysql error 1840_ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED

导入mysql数据报错：

[root@hch_test_dbm1_121_62 load_binlog]# mysql3309 mysql: [Warning] Using a password on the command line interface can be insecure.

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

[root@hch_test_dbm1_121_62 load_binlog]#

【解决方案】

mysql导入之前，先执行 reset master命令

mysql> reset master;

Query OK, 0 rows affected (0.01 sec)

mysql> exit Bye [root@hch_test_dbm1_121_62 load_binlog]# mysql3309 mysql: [Warning] Using a password on the command line interface can be insecure. [root@hch_test_dbm1_121_62 load_binlog]#