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:
- MySQL：ERROR 1067 (42000): Invalid default value for ‘end_time’
- An error was reported in the process of importing the table from mysql5.7: [err] 1067 – invalid default value for ‘***‘
- 1067 – Invalid default value for ‘sex‘1366 – Incorrect string value: ‘\xE6\x8A\x80\xE6\x9C\xAF…‘ f
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- Set the default time to the current value in MySQL
- A solution to the default invalid host only mode of CentOS virtual machine in VirtualBox
- C ා connect mysql: fatal error encountered during command execution solution
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- R ggplot Error in .Call.graphics(C_palette2, .Call(C_palette2, NULL)): invalid graphics state
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- c1: Commend line error D8021 :invalid numeric argment ‘/Wno-cpp’
- Question: cannot create windows service for mysql.error : 0 (install MySQL)
- Error in .Call.graphics(C_palette2, .Call(C_palette2, NULL)) : invalid graphics state
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- C language string processing error warning, c4996, sprintf, predicted, c4996, strcpy, c4996, strcat
- R language – error analysis – error in Call.graphics (C_ palette2, .Call(C_ palette2, NULL)) : invalid graphics state
- Top35: pychar reports an error when connecting to MySQL server returns invalid timezone. Need to set ‘servertimezone’ property
- (error when importing database): MySQL 2006-mysql server has gone away
- Xilinx Vitis arm-xilinx-eabi-gcc.exe: error: *.c: Invalid argument
- Error c2137 of C language: empty character constant (Fixed)