Issues with the user-tables in WordPress: data were not permanent - but lost after every setup: which method solves here - MD5?

[dhubs]

hello and good day dear friends


i have some trouble with the wordpress-install: well how to start: first things firrst:


i run into issues with the login - two weeks ago i lost my access to the Wordpress-site. I thought - aaaaah okay i ll have to look for the databawse and quickli set a new passwd.

so to continue: well see what happened then: the hmm - lemme asay: issue: ” setting the user_pass in DB is not permanent – it has to be renewed each login “

again: as i mentioned above: two weeks ago i lost the access to my wordpress-site:

well i thought i can fix it – due to some works in the backend – the db – in the user- table:

i found the user_pass column and change the password there. well i knew i will need to enter a new, secure password hash.

( Alternatively, i might were able to edit the user_email column to update the email address associated with the account )


Save changes: Click “Save” or “Continue” to apply the changes to the databas

i had to get the hash for the new password - first used this technique - see here: https://codebeautify.org/wordpress-password-hash-generator


Then i run this query to update the users password

UPDATE users SET user_pass = ‘NEW_HASH_HERE’ WHERE users.user_login = ‘YOUR_USERNAME’;

here a littel update:


belive it or not: i encounterred that if i set the login to the new password – with the hash – then i am only able to log in


once with the new data /and credentials -imagine: if i try to do this a secod timme then it fails –


even if i try it from another notebook – it fails –


what can i do here!`?

update: hmm to make it working again – i have to do hmm – “nasty things” :

i have to enter the term on the db again – then it will work for a one-time login!?

UPDATE wp_users SET user_pass = ‘my hash’ WHERE user_login = ‘my user name’

but belive me – thats really annouying – thats awful


what can i do – what is the solution!?


Well - did you ever have had such annoying issues - did you ever run into such awful troubles!?


plz lemme know - what do you think !?


update: hmm i did some research and found out that there might be some special - mehtods to add the user passwd:

i could ( and perhaps i should: use the MD5 Method) : see: https://stackoverflow.com/questions/46334721/change-user-pass-in-wp-user-as-md5

so if it stands so i should try something new: i could do this and

 SET user_pass = MD5(‘my password’) instead. WP

will accept it and then hash it on successful login.

see also here: https://stackoverflow.com/questions/46334721/change-user-pass-in-wp-user-as-md5

where the MD5 Method is described:

Method#1 – The Long way through phpMyAdmin table editing

This method involves editing and updating the wp_users table values to reset our lost WordPress password. The method is little longer but is also easy enough to follow without knowing technical things.

1. Head over to phpMyAdmin
2. Click on your WordPress database.
   

1. Navigate to and click the table wp_users.

1. Edit the row with your WordPress username.

1. Now, in the user_pass field, change the function to MD5 and enter your new password in the Value section (refer below screenshot).

cf: https://stackoverflow.com/questions/46334721/change-user-pass-in-wp-user-as-md5


Method#2 – The Short way through MySQL

This methods implements the direct SQL query execution to update the wp_users table value to reset our hacked WordPress password.

1. Follow the first 3 steps of the above method.
2. Go to SQL or MySQL section in your phpMyAdmin.

cf: https://stackoverflow.com/questions/46334721/change-user-pass-in-wp-user-as-md5

cf: https://stackoverflow.com/questions/46334721/change-user-pass-in-wp-user-as-md5


Concluso: i think that i lll have to try out this MD5 Method - to get rid the issues of the login problem.

what do you think!?