Locked out of MySQL

May 29, 2019 189 views
MySQL Databases Ubuntu 18.04

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.

1 Answer
dikshith May 30, 2019
Accepted Answer

You might have to revert the changes to fix it or restore it using an older backup. I would suggest you get in touch with our support team and they will be happy to help you:

https://www.digitalocean.com/company/contact/#support

Have another answer? Share your knowledge.