wordpress in localhost (linux) (3 posts)

  1. ginoxy
    Posted 8 years ago #

    hello i have downloaded wordpress on localhost (linux) yesterday and everything went fine. today whe i went to log in i forgot the password and i tried to e-mail it to me but nothing happened ! is there any way to get it back ?

  2. threestyler
    Posted 8 years ago #

    You probably could of found this yourself with a quick search of the codex for resetting password.

  3. ginoxy
    Posted 8 years ago #

    yeah i looked at it but did not get !!

    Through MySQL Command Line

    1. Get an MD5 hash of your password.
    * Visit MD5 Hasher, or...
    * Create a key with Python. or...
    * 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)

    from 6 to 9 ! i did the same but nothing happened !

Topic Closed

This topic has been closed to new replies.

About this Topic