impossible to log on as admin #767

Open
opened 2026-10-05 00:16:38 +02:00 by adam · 3 comments
Owner

i have lost password etc but i have admin access to database and files on server. in db i have some like this http://prntscr.com/imsqxc what i should do to restore admin credentials/password?
i tryed generat a new md5 hash by "SELECT MD5('new-password');

typing : "update piwigo_users set password=md5('secret') where id=1; " doesnt work ether. btw sql showing lots of errors in syntax of this query
what i should do?

i have lost password etc but i have admin access to database and files on server. in db i have some like this http://prntscr.com/imsqxc what i should do to restore admin credentials/password? i tryed generat a new md5 hash by "SELECT MD5('new-password'); typing : "update piwigo_users set password=md5('secret') where id=1; " doesnt work ether. btw sql showing lots of errors in syntax of this query what i should do? <!-- github-sync-id:303091491 -->
Author
Owner

I don't know if github issues are used as support, but why don't you just visit https://DOMAIN/password.php
enter your email, and reset it? That's what you do when you forget the password.

I don't know if github issues are used as support, but why don't you just visit https://DOMAIN/password.php enter your email, and reset it? That's what you do when you forget the password. <!-- github-comment-id:372088138 -->
Author
Owner

because i when i googled my problem only one resoneble help i was find here, some one had similar problem. i didnt use this option because i used fake email and 1st what i did was added new md5 password to db and this wasnt work

because i when i googled my problem only one resoneble help i was find here, some one had similar problem. i didnt use this option because i used fake email and 1st what i did was added new md5 password to db and this wasnt work <!-- github-comment-id:373325366 -->
Author
Owner

you can change your email in db and after you go to https://DOMAIN/password.php

you can change your email in db and after you go to https://DOMAIN/password.php <!-- github-comment-id:395200116 -->
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#767