Hi, hope you are doing great. 
I’m trying to configure Ghost, and after the installation, Ghost is functional. However, after 10min, it enters a redirection loop. I’m unsure whether the issue lies with Cloudflare, Ghost, or Ghost’s private mode. I would appreciate any insights you can provide on this matter.
i think i found the answer trying this now
https://github.com/TryGhost/Ghost/issues/2796#issuecomment-392327647
@Hari what is being displayed in the console?
@phenomlab idk, i think the issue with CF always SSL setting. i had to turn it off and let the nginx handle http>https . not sure this is safe approach or not for now the site is in under construction mode with ghost. we might move to ghost in 6 months the migration is the big task. wordpress and ghost both have their own pros and cons 
@Hari I would anyways have nginx handle the redirect between http and https anyway.
@phenomlab New query: I’m attempting to install multiple instances of Ghost on a single droplet. I’ve completed the initial setup using the 1-click Digital Ocean setup as outlined in the following guide:
However, while following the instructions in the above guide, I encountered an issue with the MySQL root passwords. I’m unsure about what went wrong, and I’m unable to determine the current MySQL root password. I’ve tried several commands found online, but none have been successful. Any suggestions? Please advise.
i have tried figuring out the root passwords and i could not do it. now going for a fresh ubutu droplet
I have found ways to properly modify root passowrd here, going with old droplet now 
https://vegastack.com/tutorials/how-to-install-ghost-on-ubuntu-22-04/
