Admin Password Help

More
3 years 11 months ago #101666 by rschroeder
rschroeder created the topic: Admin Password Help
Is there a way you can reset the "admin" password if it's been lost after installation and set-up? Personnel changes have resulted in a loss of the password and we can no longer log in through the server. Thanks in advance for your assistance.

Please Log in to join the conversation.

More
3 years 10 months ago #101674 by Ben_V
Ben_V replied the topic: Admin Password Help
Hi,
You may have a look here ;)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Please Log in to join the conversation.

More
3 years 10 months ago #101675 by rschroeder
rschroeder replied the topic: Admin Password Help
Thanks Ben for the information. Does the SQL script remove all users or can it just reset the admin password? I don't want to remove all of the accounts listed in the application.

Please Log in to join the conversation.

More
3 years 10 months ago #101687 by Ben_V
Ben_V replied the topic: Admin Password Help
Yes it will overwrite all the `lime_users` table and delete users (due to the "DROP TABLE IF EXISTS" statement)

If you only have 1 admin account just this query to only update the password value. Admin username won't be affected (only the passw will be updated to "password").

Be careful if other users are sharing admin rights because their passwords will be updated too. In this case edit the query changing 'superadmin=1' by another field and value present into your `lime_users` table
UPDATE lime_users SET password=0x64666332353762396662343161396663333138666131313034303063343461333136653863616661303066356230356536396264623466646438656665616664 WHERE superadmin=1

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Please Log in to join the conversation.

More
3 years 10 months ago #101756 by rschroeder
rschroeder replied the topic: Admin Password Help
Thanks again Ben for all of your assistance.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now