This is because the current database version is higher and some parameters need to be changed
Solution:
In the sql file
utf8mb4_0900_ai_ciReplace utf8_general_ci
utf8mb4withutf8
Run the SQL file again
Read More:
- [MySQL] Note that MySQL5.1 does not support utf8mb4 Error 1115: Unknown character set:’utf8mb4′
- MySQL character set error resolution: err=Error 3988: Conversion from collation utf8mb4_unicode_ci into utf8_general_ci impo
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- [Solved] Windows MYSQL Error: django.db.utils.OperationalError: (2026, ‘SSL connection error: unknown error number‘)
- [Solved] MYSQL Error: unknown error 1130, unknown error 1045
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- C# Connect MYSQL Error: MySql.Data.MySqlClient.MySqlException:“SSL Connection error.”
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- SqlSugar Connect MySql 8.0.29 Error [How to Solve]