I can't access to my admin panel (D7)

[freddyminute]

I can't not access to my admin panel. My username and passeword are not recognised. I did not modify any things but suddently I have been refused access. My website is congofive.com I tried to find the table in the database where username and password are stored but it 's not easy as there more than 300 tables in the database.

Could help me to sort out this problem because I can't do nothing. Regards Freddy M

[kreativ]

Replying to freddyminute:

I can't not access to my admin panel. My username and passeword are not recognised. I did not modify any things but suddently I have been refused access. My website is congofive.com I tried to find the table in the database where username and password are stored but it 's not easy as there more than 300 tables in the database.

Could help me to sort out this problem because I can't do nothing. Regards Freddy M

Hi,
you can fix this by copying a known password from a "backup user",
or you can create a new password by running these sql queries:

UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID` = '1' LIMIT 1
UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('yourNewPassword'), `Salt`)) WHERE `ID` = '1' LIMIT 1

well, you can actually just skip the first one.

This worked to generate a user password for most users, some needed a manual fix for unknown reason - probably different character set in old passwords.
No idea why your password stopped working though... Some users reported similar, but believed to be profile not active mostly. Copy current encrypted password and salt for testing maybe.. (paste to other user and try login).