Change forgotten password on local Webmatrix install?

  • I locked my self out of a local WP install on Webmatrix (which, sadly, is operating and the company is using it). All the tutorials are for phpMyadmin, and Webmatrix is using a different database manager, SQL Express or Management Studio, or something like that.

    I tried adding “wp_set_password( ‘password’, 1 );” to the start of wp-config file as described in WP codex , but it breaks my site, and doesn’t change the password.

    All the tutorials make it pretty eay to do inphpmyadmin, change pass, click MD5 to hash it and that’s it. But, in Webmatrix there is no MD5 option, only cells with basic users info. I can get it to highlight the pass so I can edit it, but not sure what will hapen. Don’t want to mess things up even further.

    What should I do?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Do you have mysql command line access?

    Thread Starter fringer

    (@fringer)

    Unfortunately no. But, I can change the database value directly in webmatrix, its database tool allows me to do it, though I’m not really sure what will hapen.

    • This reply was modified 7 years, 11 months ago by fringer.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You can use a site like https://www.miraclesalad.com/webtools/md5.php to make an MD5 if your application doesn’t support it.

    Thread Starter fringer

    (@fringer)

    Now I have root access to the database. I used instructions from here.

    Then I used instructions from WP to change the wp password, using the option to have SQL compute the hash. When I connect to the database, I can see the hash value is now different, but I still can’t login to WP with the password I specified.

    I double checked, and I was using the correct database, and I did everything according to instructions, but I still can’t login to the site. What can I do next?

    • This reply was modified 7 years, 11 months ago by fringer.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    what is the exact error you get when you try to login?

    Thread Starter fringer

    (@fringer)

    I’m not near the machine now to give the exact error, but it’s the standard error you get when you enter the wrong password. No error code or anything, just the basic “wrong password”.

    The database is correct, and I typed the password correctly, I double cecked both of those.

    The weird thig is that while I was resetting the MySql password from the command line, after I typed the command for changing the password, the cmd cursor was just blinking for like 10 minutes, so I finally switched it off, and tried logging to MySql with new password and it worked.

    • This reply was modified 7 years, 11 months ago by fringer.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You changed the MySQL password or your WordPress password? They’re not the same thing.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Change forgotten password on local Webmatrix install?’ is closed to new replies.