Report this

What is the reason for this report?

Locked out of MySQL

Posted on May 29, 2019

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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.