So, I was playing around in the settings of phpMyAdmin on my DigitalOcean server. I looked at the security settings and saw the password hashing method dropdown. Being the idiot I was, I was making a social media app, so I thought it should have the best encryption, right? Wrong. I set it to SHA256 and COMPLETELY IGNORED the part where it said I needed an SSL certificate and now I can't change it. At all. I don't have an SSL certificate. I've tried the good ol' stop-MySQL-and-then-change-the-password trick, but still no dice.
Ubuntu 18.04, MySQL latest. Please help.