CMS Made Simple Admin password recovery

  Previous article Next article  

CMS Made Simple Admin password recovery

  Article optimized for CMSMS 2.x

  Author:
  Last tested in: CMSMS 2.1.6
  Last updated: 20-01-2017
  Comments: 0

Oops, you forgot your CMS Made Simple™ Admin credentials... Now what?
This video tutorial shows you how to find out your user name, reset your password and give you access to the Admin panel again.


  Tutorial Video


The video shows you:

  • how to reset the Admin password by using the "Forgot your password" feature,
  • set/change the mail address in the database for the Admin user and
  • reset the password with a SQL query.

If you can't remember your user name either, once in the database you can read it in the cms_users table!

You can find the database credentials in the CMSMS™ config.php file in the root of the website.

With this universal database query you can reset the password:

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'

Just change the required password and the matching Admin user name. The example query used in the video is:

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

Afterwards the user "cmsmsadmin" could log into the CMSMS Admin panel again with the temporary pass "chang3m3" and updated his credentials at My Preferences >> My Account

In this tutorial I assume the database prefix has the default value "cms_". If this is changed in your install, see the config.php file, you need to change the prefix in all code used in this article.


A2 Webhosting CMS Made Simple

More information at:



A2 Webhosting CMS Made Simple

  Comments

  Click here to leave a comment






This is a captcha-picture. It is used to prevent mass-access by robots. (see: www.captcha.net)
  « Enter the CAPTCHA code (lower case)

Your IP address will be stored on submit. I reserve the right to change or delete your response without notice!
In case of abuse your IP address will be blocked!


Can I have your attention for a moment?

Did this tutorial help you solving a problem at your (clients) website and it saved you many hours of work? Great!!
Consider buying Rolf a cup of coffee in return! [ Click here ]

CMS Made Simple 2.1.6 - Tutorials, tips and tricks - CMSMS 2.1.6

CMS Made Simple Admin password recovery

  Article optimized for CMSMS 2.x

  Author:
  Last tested in: CMSMS 2.1.6
  Last updated: 20-01-2017
  Comments: 0

A2 Webhosting CMS Made Simple