修改wordpress密码

Through MySQL Command Line

  1. Get an MD5 hash of your password.
    • Visit MD5 Hasher (http://bfl.rctek.com/tools/?tool=hasher), or...
    • Create a key with Python. or...
    • On Unix: echo -n | 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)

没有评论: