• Resolved rcmullins

    (@rcmullins)


    Does anyone know how WP authenticates to the DB? specifically relating to the Admin password? Is it hashed?

    I changed the admin password via the backend to the dbase, and now having trouble getting in.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Check out https://www.tamba2.org.uk/wordpress/phpmyadmin/

    It would appear to be MD5 hashed.

    Thread Starter rcmullins

    (@rcmullins)

    I think this is going to work. FAntastice, thanks handySolo!!!!

    Thread Starter rcmullins

    (@rcmullins)

    Well, it looked nice anyway. The set-up of phpMyAdmin is a brutal process that is not very explanatory. The basic idea is easy enough, but creating that set-up script is a drag. Are there any other ways to hash with MD5 than the phpmyadmin?

    Thread Starter rcmullins

    (@rcmullins)

    HandySolo: I figured out a way to do it, without using the phpMyAdmin thing. Using a sql command you can hash using the MD5 hashing algorithm. Its really quite easy too. Thanks to you for pointing me in the right direction. Here is the query.

    UPDATE wp_users SET user_pass = MD5(‘mypass’) WHERE ID = 1;

    For anyone out there here is how it works.

    You log into your wordpress database within MySQL. There are several ways to do this, using the commanline or the new MySQL query analyzer. The password and user information is located in the table wp_users. Once you are ‘using’ the correct database you just execute the above command/query. Since all the admin stuff is located in id# 1 the only thing you will have to alter is the ‘mypass’ part. Just fill in your desired password, and you should be set.

    Anybody who needs more explanation on this, please feel free to email me at;
    [email protected] It may take me a day to get to you, but I will try to respond the best way I know how.

    Thanks again to HandySolo for helpin meh.

    Nice alternative ?? Happy blogging

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Athentication’ is closed to new replies.