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;