mysql -u root -pTurns out there’s a wp_users table in there. For my user I was able to do the following (replacing MYUSERNAME with my actual username):
SELECT MYUSERNAME FROM `wp_users`Then the following (again assuming MYUSERNAME is the user and now substituting MYPASSWORD with the password you want to use – lucky us that md5 is supported from the mysql CLI now, as that’s what WordPress is gonna’ want us to use):
UPDATE wp_users SET user_pass = MD5(‘”(MYPASSWORD)”‘) WHERE ID = MYUSERNAMEAnd then viola I was back to writing the same old dribble once again. I had been really busy finishing off some chapters and so hadn’t bothered to figure it out. Now I’ll be back to it. Lucky you, right?!?!
krypted April 13th, 2010