Mysql database import SQL error (unknown collation: ‘utf8mb4_ 0900_ ai_ ci’ )

Time:2021-3-6

Mysql database import SQL error (unknown collation: 'utf8mb4_ 0900_ ai_ ci' )
Mysql database import SQL error (unknown collation: 'utf8mb4_ 0900_ ai_ ci' )
Error reason: high version database (8.0) transfers SQL file and imports low version database (5.7)

terms of settlement:

Scheme 1: upgrade Mysql to a higher version

Scheme 2: the SQL file to be imported, the

utf8mb4_0900_ai_ciReplace all withutf8_general_ci

utf8mb4Replace withutf8

Re execute SQL file