WordPress import database error Unknown collation: utf8mb4_unicode_520_ci solution

When importing a database into the local environment today, the prompt #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ is incorrect, as shown below:

The reason is that the difference in the database version causes the wordpress database to be coded in different ways. In MySQL 5.6 and above, when WordPress 4.6 and above are installed, the default encoding is utf8mb4_unicode_520_ci, but MySQL 5.5 and below does not support utf8mb4_unicode_520_ci, so it cannot be imported.

The processing method is to use a code editor such as sublime text, open the .sql database, and then batch search and replace all utf8mb4_unicode_520_ci to utf8mb4_unicode_ci, save and upload.