hello and good day dear friends
- good evening,
![]()
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:
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
wordpress-password-hash-generator
Then i run this query to update the users password
Code:
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!`?
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!?
Code:
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# greetings ![]()