I created a new lightsail ghost instance, configured it and made sure it was working ok, and then exported everything from the old instance and imported them to the new instance. I also had to copied over the images directory and update the links manually instead of messing with the database. I can share my notes if you DM me.
Thank you for your help, I finally identified my issues. I am hosting my vuejs webapp on cloudfront and ghost was host under /blog subdirectory. The issue is that I customized a 403 error page response for my webapp, which applied to the api call every time when I visit the ghost admin login page and somehow preventing me login to the dashboard. I was struggling here for last 2 days
I really like your blog theme, especially the table of content feature, did you customized it or it comes with the theme? What theme are you using? If you customized the ToC feature, can you please share it with me?