reset admin pasword

[jubgmbh]

Hi,
I forgot my admin PW. So I requested a reset mail but I don´t receive a mail to reset the PW on none of my email accounts.
What can I do?
BR Uwe

[Rolf]

This video tutorial will help you:
https://cmscanbesimple.org/blog/cms-mad ... d-recovery

[jubgmbh]

Tanks for the link. It was good for understanding.
I changed my PW directly in the db but it still doesn´t work. Is the encrption method MD5?
BR Uwe

[Rolf]

No, it is not! You need to use the script provided in the tutorial.

I looked at your website, be sure you first fix any mixed content issue when using SSL.

grtz. Rolf


ps. https://cmscanbesimple.org/blog/setting ... ade-simple

[jubgmbh]

Thanks Rolf,

I will try later today or tomorrow.
BR Uwe

[jubgmbh]

Hi,
I tried to use your script.
Unfortunatly is doesn´t run. I changed the tabel names to my table names and die values to my values.
But I get syntax errors what is strange. This appears already when I just copy your command into the SQL field of phpMyAdmin.
eg: unrecognized keyword at "set password", unexpected sign at "=", unexpected sign at "(" and some other.
Any idea?
BR Uwe

[velden]

Put backticks around password

Code: Select all

update cms_users set `password` = (select md5(CONCAT(IFNULL((SELECT sitepref_value FROM cms_siteprefs WHERE sitepref_name = 'sitemask'),''),'NEW_PASSWORD'))) where username = 'USER_NAME'