The solution of using MySQL to import data garbled error in Windows environment

Using source xxx.sql for Linux and Mac systems can import test data directly (note that you must first switch to the current Xxx.sql directory),

But in the Windows environment import will appear garbled error,

Mainly because of the coding problem, the workaround is as follows:

1. Switch the path to the Xxx.sql directory first;

2. Log in to MySQL database using cmd or PowerShell;

3. First enter set names UTF8

4. Re-enter the source Xxx.sql (or drag the folder to the terminal)

The solution of using MySQL to import data garbled error in Windows environment