I cannot login anymore..

[johnvdv]

Hello all,

I'm afraid I forgot my passwd and now I cannot login anymore.. (I installed more than a year ago, and now I want to add photos)
Can someone help me please?

[johnvdv]

I'm always thrown back to the log-in page, I was pretty sure about my name and passwd..

I do not have an emailrecovery button
and this does not work neither, I get a blank page..:
"Place this file (password_recovery.php) in the root of your site and run it. Fill in all questions and you will have a totally new and fresh password"

[Dennis]

johnvdv: do you have access to PHPMyAdmin?

[johnvdv]

yes I have

[Dennis]

you can execute a query to update the password then.


UPDATE `pixelpost_config` SET `password`=MD5('yourpassword') WHERE `id`=1


If your username is still admin you can change it to something less obvious:

UPDATE `pixelpost_config` SET `admin`='newusername' WHERE `id`=1

[johnvdv]

Thank you for your answer Dennis

Error
SQL query:

UPDATE `pixelpost_config` SET `password` = MD5( 'mypsswd' ) WHERE `id` =1

MySQL said: Documentation
#1146 - Table 'johns_fotothing.pixelpost_config' doesn't exist

I do not know what I am doing wrong here, but I have never tampered with db before..

[johnvdv]

OK, error is gone. (it was because I changed the name from pixelpost to photopixel),
but now i am stuck here and I'm afraid to mess up my databases:
"You have to choose at least one column to display"

and I have to choose a field, and sort, show ?

[Dennis]

Uhm, if you executed the query and it returned something like "One row affected" you're good to go.

That is it.