Some issues with the Login into a WordPress-Site

hello and good day dear friends :heart_eyes: - good evening, :smile: :heart_eyes:

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 :heart_eyes:

Wordpress offers “forgot password” option at login. Use that.

1 Like