By looking at my database through PHPMyAdmin, I noticed that multiple tables were missing, like wp_users, wp_posts, etc, which would explain why I can’t login and why no posts / pages are working.
I managed to copy the wp_user and wp_usersmeta from an old DB backup to finally login. There’s no content on the site though, so I might have been hacked, I’ll keep looking into it.