New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

impossible to log on as admin #580

Closed
satyan01 opened this Issue Dec 19, 2016 · 4 comments

Comments

Projects
None yet
5 participants
@satyan01
Copy link

satyan01 commented Dec 19, 2016

Hello

how Can I reset my admin password ? I have tried with md5 translation

go to mysite/admin.php

I am redirected to identification.php but my credentials don't work.

Help please

@plegall

This comment has been minimized.

Copy link
Member

plegall commented Dec 20, 2016

In your database, you can apply the SQL query:

update piwigo_users set password=md5('secret') where id=1;

Then you can use password "secret". Piwigo will automatically convert to a more secure hashing algorithm.

Warning: username and password are case-sensitive

@plegall plegall closed this Jun 14, 2017

@dr-coctor

This comment has been minimized.

Copy link

dr-coctor commented Mar 4, 2018

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?
maby i doing some thing wrong but copy those query dont work im my case

@BlackH137

This comment has been minimized.

Copy link

BlackH137 commented Jan 14, 2019

Hi

Our old administrator left.
I can log into the Linux PC that hosts the Files, but I do not have the username or password to log into the WebUI. is there a way to change or reset passwords on the server locally?

@in8sworld

This comment has been minimized.

Copy link

in8sworld commented Jan 14, 2019

You'll need to follow the instructions above to reset the password in the database. Look for phpmyadmin somewhere in the live web files folder. If it doesn't exist you you can either set it up yourself (get ready to do some googling) or you'll have to use the terminal to run the update command against the mysql database.

You can get phpmyadmin here: https://www.phpmyadmin.net/downloads/

If its already installed, you just point your browser to load up that location and it provides a nice GUI to modify data in your database and for many things you can avoid the command line. Either way for this application you still have to run the update command as given earlier in this thread:

update piwigo_users set password=md5('secret') where id=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment