When mysql imports the database, the error 1840 solution is returned. mysql1840

When mysql imports the database, the error 1840 solution is returned. mysql1840

1. symptom

When mysql imports a database using an SQL file, the ERROR 1840 (HY000) at line 24: @ GLOBAL. GTID_PURGED can only be set when @ GLOBAL. GTID_EXECUTED is empty.

Note: the mysql database has just been installed and has never been configured with master-slave replication or GTID.

2. Solution

After checking the online materials, I found that the following method can solve my problem.

Enter mysql mode and reset the master

# Mysql-u root-p

Enter Password

Mysql> reset master;

After exiting, re-import the data. OK. Let the machine import the data on its own.