Unable to Login as Admin

The current version of WordPress is 6.6.1, I assume you mean this one.

When you are logged in, have a look under Tools > Site Health to see if there are any anomalies.

Deactivate all plugins if you have already installed and activated any.

Take a look at your user’s password field in the database. This is an encrypted value and if you reset the identical password, it should have the same value as before.

Hi @threadi,

I used Adminer to check the value of my current password. After that I tried to set the same password with MD5 option and saved it. To my surprise, I found it to be different value.

What am I missing here?

Site health shows that 2 php modules are missing. Imagemagick and Intl

I have installed the Intl but couldn’t find the Imagemagick for PHP 8.3

Thanks!

• This reply was modified 3 months, 3 weeks ago by Deepak.
• This reply was modified 3 months, 3 weeks ago by Deepak.

Hi @threadi,

Just to give you an idea, this is what I performed

After resetting my password through reset form, I found this on database $P$BZIXqmG3qY6J/bLX5NvbdPVfPWJTHS/

I logged out from the Admin and tried to login again gives me invalid passowrd

So, I tried to save the same password in database using MD5. After saving it, I found this value for the same password

d7b72e9695980709cc60892e858c18ac

The I tried to log back in with same Admin credentials. This time also it says, invalid password.

Not sure what’s going on. Is there something in the middle is encrypting this twice?

Also, I have tried to reset the password few times. To my surprise, the value stored in the database is different each time I reset via reset form.

Thanks!

• This reply was modified 3 months, 3 weeks ago by Deepak.

For security reasons, WordPress only uses MD5 passwords for database resets. As soon as you log in with the password, the password is stored in a different encrypted form. The fact that the value changes is therefore intentional. However, it should not change if you log in a second time with the password.

Imagick should have no influence on the password problem. Intl, on the other hand, does. Has the behavior not changed after installing it?

Have you tried logging in with a different browser?

Hi, @d88pak.

If you still can’t log in, try setting the primary key in the wp_usermeta table to auto increment. Some users have experienced similar issues and were able to log in again after making this change.

For detailed instructions, you can check the following links:

• Error: Duplicate entry ‘0’ for key ‘PRIMARY’
• How to add auto increment to a column in MySQL database using phpMyAdmin

Hello All,

Seems like php-intl have something to do. After installing this, now I can login normally each time.

@saadahsan I have checked the database. There was no issue. both wp_usermata and wp_users have primary key set to autoincrement.

Thank you all!