MySQL 8.0

来自WHY42
  • In MySQL 8.0, utf8mb4 is the default character set and uses a more modern utf8mb4_0900_ai_ci collation as the default. The prior version of MySQL 5.7 supported the utf8mb4_unicode_520_ci collation but not the latest version of Unicode utf8mb4_0900_ai_ci.
  • MySQL 8.0 introduces roles for managing privileges but this feature did not exist in MySQL 5.7[1].