ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci' Query OK, 0 rows affected (0.00 sec) ERROR 11462S02): Table 'fizz_manager.blade_user' doesn't exist

 


ERROR 1273 (HY000): Unknown collation: ‘utf8mb4_0900_ai_ci‘
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table ‘fizz_manager.blade_user‘ doesn‘t exist
ERROR 1146 (42S02): Table ‘fizz_manager.blade_user‘ doesn‘t exist
ERROR 1146 (42S02): Table ‘fizz_manager.blade_user‘ doesn‘t exist
ERROR 1146 (42S02): Table ‘fizz_manager.blade_user‘ doesn‘t exist

解决方法:
打开sql文件,将文件中的所有
utf8mb4_0900_ai_ci替换为utf8_general_ci
utf8mb4替换为utf8
保存后再次运行sql文件,运行成功

ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci' Query OK, 0 rows affected (0.00 sec) ERROR 11462S02): Table 'fizz_manager.blade_user' doesn't exist

上一篇:leetcode 中等难度


下一篇:Enable OWIN Cross-origin Request