Been fighting with resetting the
root password for MySQL on an Amazon Linux hosted on EC2. Version:
mysql Ver 14.14 Distrib 5.5.42, for Linux (x86_64) using readline 5.1
When installing, I decided it would be smart to change the root password to something secure! Yay! Security! Except it won’t let me log in with that password now, so I’m trying to reset it.
I followed the instructions here, but it’s not working. I thought it might be permissions on the init file, but they're set to
rwxrwxrwt so probably not, but maybe? Not even sure what log files to check to see where it's going wrong either.
So, how can I successfully reset the MySQL password on EC2 Amazon Linux? Is the set of instructions linked to supposed to work, or does Amazon do something differently?
Also I asked this on ServerFault, but it wasn’t “clear” what I was asking. I’d say this is rather off topic for here too, but…