MySql Error1067:Invalid default value for ‘c_Gender‘

The following error occurred when importing the MySQL script ebuy.txt file:

Error1067、Error1146

On the command line, enter show variables like ‘% character%’; View character set

 

  As shown in the figure above, my question is character_ set_ Database and character_ set_ server

At the command line, enter set   character_ set_ database=utf8mb4;

                       set   character_ set_ server=utf8mb4;

Then delete the original Ebuy database and run the script again.

Read More: