MySQL 报错 'Unknown collation: 'utf8mb4_0900_ai_ci'' 解决方法

以下 SQL 语句报错：'Unknown collation: 'utf8mb4_0900_ai_ci'' 怎么修改

DROP TABLE IF EXISTS admin; CREATE TABLE admin ( Aid int(0) NOT NULL AUTO_INCREMENT, Ausername varchar(40) CHARACTER SET utf8mb4 COLLATE 'utf8mb4_general_ci' NOT NULL, Apassword varchar(40) CHARACTER SET utf8mb4 COLLATE 'utf8mb4_general_ci' NULL DEFAULT '123', Aphone varchar(40) CHARACTER SET utf8mb4 COLLATE 'utf8mb4_general_ci' NULL DEFAULT NULL, Aavatar varchar(255) CHARACTER SET utf8mb4 COLLATE 'utf8mb4_general_ci' NULL DEFAULT NULL, Atime timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (Aid) USING BTREE, UNIQUE INDEX Ausername(Ausername) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8mb4 COLLATE = 'utf8mb4_general_ci' ROW_FORMAT = Dynamic;

将 'utf8mb4_0900_ai_ci' 改为 'utf8mb4_general_ci' 即可。