MySQL Passwords randomly reset (second time in two months)
For the second time now, I've had to stop mysqld and run it with –skip-grant-tables to log into my mysql account and reset the root password and a user password I'm using for a WordPress installation (that should only have privileges to the database it's using). I use UPDATE mysql.user SET…. etc.
I'm concerned I'm hacked or something, but don't have much experience investigating security loopholes beyond following the Linode instructions diligently (including securing the installaiton) and making sure that MySQL users only have the privileges they need (and not using root for anything other than SSH access). I'm going to put the password portion of my wp-config.php in a folder outside the public directory and do an includes in that file instead, but my feeling is it has something to do with the server. My passwords aren't brainless, and I can fix this problem pretty easily.
But just wondering-- why does it happen?
Btw, the way I find out is I go to my website and I see "Error establishing database connection." Any help would be appreciated. Thanks!
Best,
Jessica
1 Reply
James.