Loading...
 
Skip to main content

History: Lost admin password

Preview of version: 25

lost admin password


If you can login with a user in Admins group (with permission tiki_p_admin), you can go to
tiki-admin.php?page=general and look for "Admin password" section.

If you can't login, Starting in version 3.0, you can set the admin password in the installer (tiki-install.php), so the procedure below will no longer be necessary.
Warning: This possibility appears to have been removed or broken as of Tiki 12. I did not manage to reset the password this way on Tiki 15.


If you using an older version, please see below.



If you have lost the admin password for your site you will need access to the tiki database to change the password manually.

Assuming you are not using external user authentication - the password you lost is lodged firmly in your database.

1. Access your web hosting control panel (usually CPanel). If you can't find or login to Cpanel, contact your ISP.

2. Once logged into Cpanel, goto MySQL Databases, then (scroll way down!) open the PHPMyAdmin panel.

3. Select your database (usually something_tiki) from the drop-down list of databases on the left.

4. Scroll down the list of tables (way down) and select (browse) the users_users table. The password will be in there.

NOTE:If the "password" field is blank - your passwords are encrypted (which is the default and recommended setting). Typing in a password will not work. See (if you could) Admin>Login>Store plaintext passwords for this setting. (this feature was removed quite a while ago . Goto Step 5

Image
and then
Image

5. In case your tiki encrypts password (which is recommended) you can use the following SQL command

  • click on the SQL tab.
  • cut and paste the following exactly into the SQL window in PHPMyAdmin.

Copy to clipboard
UPDATE `users_users` SET `password`='admin', `hash`= md5('admin') WHERE `login`='admin';


this will set the password to "admin" again. You are saved.

Newer versions of Tiki (maybe around >=15.x - anyone know better?) don't have the password field in the users_users table any more, so the command changes to:

Copy to clipboard
UPDATE `users_users` SET `hash`= md5('admin') WHERE `login`='admin';


6. Login with
username: admin
pasword: admin

7. Proceed to the "Change admin password" section of tiki-admin.php?page=general
Change to safe password.



History

Advanced
Information Version
Marc Laporte simpler 27
Bernard Sfez / Tiki Specialist Adding information since Tiki 18 console command addition 26
Philippe Cloutier 25
Marc Laporte 24
Philippe Cloutier Edit restored by rescue script 2017-04-24T18:09:12+00:00 23
amette Update SQL command for newer Tiki versions 22
Jean-Marc Libs 21
Marc Laporte 19
Marc Laporte 18
Marc Laporte just updated from a question to security list 17
Marc Laporte 16
Marc Laporte 15
Marc Laporte do not add links for yet to be created pages 14
Marc Laporte adding info about changing your password 13
Marc Laporte default setting 12
mlpvolt 11
mlpvolt 10
mlpvolt 9
mlpvolt 8
mlpvolt 7
mlpvolt 6
mlpvolt 5
mlpvolt 4
mlpvolt 3
mlpvolt 2
mlpvolt 1