Page 1 of 1
reset admin pasword
Posted: Sun Mar 29, 2020 12:11 pm
by 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
Re: reset admin pasword
Posted: Sun Mar 29, 2020 12:36 pm
by Rolf
Re: reset admin pasword
Posted: Wed Apr 01, 2020 3:30 pm
by 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
Re: reset admin pasword
Posted: Wed Apr 01, 2020 6:38 pm
by 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
Re: reset admin pasword
Posted: Thu Apr 02, 2020 10:45 am
by jubgmbh
Thanks Rolf,
I will try later today or tomorrow.
BR Uwe
Re: reset admin pasword
Posted: Sun Apr 05, 2020 11:23 am
by 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
Re: reset admin pasword
Posted: Fri Apr 10, 2020 10:41 am
by 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'