MENU

CMS Made Simple Admin password recovery

  Previous article Next article  

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.

More information at:




  Comment Form

Click here to open the form


  0 Comments

No comments yet...

CMS Made Simple - Tutorials, tips and tricks - CMSMS

CMS Made Simple Admin password recovery

  Article optimized for CMSMS 2.x

  Author:
  Last tested in: CMSMS 2.2.7
  Last updated: 31-03-2018
  Comments: 0
  http://cms.ms/lUYz

Advertisement



Ads help me to help you! Thanks!