The character set and collation rules of Mysql8.0 are different from MySQL5.7, as follows:
The table code is utf8mb4_0900_ai_ci
The sorting rule is utf8mb4
utf8mb4 is replaced with utf8
If you want to lower the version during development, you need to process the .sql file directly.
This article is processed based on the netizens' ideas and replaces the following content with the help of notpad++8.1.9:
utf8mb4_0900_ai_ci is replaced with utf8_general_ci
utf8_croatian_ci is replaced with utf8_general_ci
utf8mb4_general_ci is replaced with utf8_general_ci
utf8mb4 is replaced with utf8
Then run the database .sql file into MySQL 5.7, OK!