password rejected when migrating files to local host

There must be something here that I am missing as I have just migrated the site to the local host using all in one Wp migration plug-in which worked well but now when I try to login to the Wp-admin dashboard I am having the same problem with all passwords being rejected. Thanks

@donalmccaffrey –

The easiest way to remedy your situation is to change your now local admin user via the database using phpMyAdmin.

– fire up phpMyAdmin from WAMP
– expand the users table and edit the admin user name (if you want) and enter a new password as normal text
– the key for this to work is the make sure you select MD5 from the user_pass varchar(255) drop down and then click Go

That will get you in with the credentials you entered ??

Cheers!
Lyle

Thanks for the help Lyle
When you say, expand the users table, the only thing I see on My WAMP phpMyAdmin is the ‘Users Account’ tab which (using edit privileges tab) allows me to edit password of existing account or add a new user account. I don’t think this is what you are referring to but I don’t see the users table you mention. Sorry for the hassle but if you maybe pinpoint where it should be. Also the MD5 from the user_pass varchar(255) you mention – is that a separate file or part of the same users table.
Many thanks

@donalmccaffrey –

Nope, it is the db for your site ?? Open phpMyAdmin and you will see a listing of the dbs in your WAMP install in the left sidebar. Expand the one for the site in question. Once you do that, you will see a listing of all the tables in that db. Click on the wp_users table. Go from there ??

• This reply was modified 7 years, 10 months ago by snifflevalve. Reason: typo
• This reply was modified 7 years, 10 months ago by snifflevalve.

Lyle
I think I have found the user table (one for each site per database), which shows – still not sure where the ‘user_pass varchar’ is? I see you have just sent a message, will send this on

That’s it Lyle,,, don’t see any indication of the ‘user_pass varchar’ you refer to?

I think I have it,,,, thanks a million,,,I would never have worked this one out. I’ll come back in a while to mark as resolved.

It’s all working great – thanks again

Lyle
Related to the above can I just check with you how I can change the username in the wp – users table. Do I also select MD5 from the user_login varchar(60) drop down – the same as the user_pass varchar(255) or do I choose a different option. I tried this but it didn’t seem to work. Thanks for your help again

@donalmccaffrey –

The username is just a text field and you don’t select the MD5 for that; just edit the name, no spaces, and click Go ??

Thanks very much