Can't log in past "This site is private"

I suddenly can’t log into my site, and entering my password at “This Site is Private” just says the password is wrong, I then followed the instructions for changing the hashed password via MySQL and in the users table, but I’m still stuck. What can I do?

The private page is for your front end, and the password is available in the admin panel. You can log in to the admin panel by adding /ghost to your site url (e.g my.site/ghost)