Wordpress Passwort verloren
Falls der Mailer nicht eingerichtet ist und somit die Maillösung nicht in Frage kommt, ist noch nichts verloren, jedenfalls solange man Zugfriff auf die Datenbank hat. Entweder man macht das über irgendwelche Tools, die es erlauben, in die Datenbank zu schreiben oder man macht es direkt via mysql.
1. Get an MD5 hash of your password.
* On Unix: echo -n <password> | md5sum
2. “mysql -u root -p” (log in to MySQL)
3. enter your mysql password
4. “use (name-of-database)” (select WordPress database)
5. “show tables;” (you’re looking for a table name with “users” at the end)
6. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (this gives you an idea of what’s going on inside)
7. “UPDATE (name-of-table-you-found) SET user_pass=”(MD5-string-you-made)” WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)
8. “SELECT ID, user_login, user_pass FROM (name-of-table-you-found)” (confirm that it was changed)
9. (type Control-D, to exit mysql client)Note if you have a recent version of MySQL (version 5.x?) you can have MySQL compute the MD5 hash for you.
1. Skip step 1. above.
2. Do the following for step 7. instead.
* “UPDATE (name-of-table-you-found) SET user_pass = MD5(‘”(new-password)”‘) WHERE ID = (id#-of-account-you-are-reseting-password-for)” (actually changes the password)
Mai 18, 2009 | Posted by willi
Categories:
Tags:

Letzte Kommentare