Mysql collation errors

Upgrading to MySQL 8 changes the default database collation and charset. When using with Ghost, it throws column mis-match error.

Quick Fix:

  1. Drop the database.
  2. Create a new database with the same name.
  3. Restore data from DB back-up.
  4. Connect to MySQL server and set the correct collation and charset.
-- for ghost, these setting works
ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;