You never need to delete your database when updating Ghost. It sounds like your MySQL version updated to version 8 which changes the default character set and creates issues due to conflicting character sets between tables.
The issue is well documented here: