@jeff is right. MySQL 5 worked ok with Ghost 5.22, but it hasn’t been officially supported since 5.0, and 5.21.0 broke something.
You’ll either need to upgrade MySQL to 8.0+ or install Ghost no higher than 5.20.0. Since the Ghost team rolls out new features regularly, it’s worth solving the MySQL problem.