Changes between Version 7 and Version 8 of GenFAQ

Timestamp:

Sep 2, 2011, 5:35:15 PM (14 years ago)

Author:

IgorL

Comment:

--

GenFAQ

@@ -5 +5 @@
 '''[http://www.boonex.com/trac/dolphin/wiki/GenFAQ#HowcanIchangethetimezoneinDolphin How can I change the time zone in Dolphin?]'''
 
-
+'''[HowcanIchangeadminusernameandorpasswordifIforgotit How can I change admin username and/or password if I forgot it?]'''
 
 ----
@@ -103 +103 @@
 
 This is it. Now the time on all pages and in all widgets should correspond to admin's local time.
+
+----
+
+== '''''How can I change admin username and/or password if I forgot it?''''' ==
+
+If you forgot your admin access or somehow can't access your admin account, you can create a new admin account or change the password of the existing account if you remember its name ('''''admin''''' by default).
+
+'''1)''' Log into your '''phpMyAdmin''' page (should be accessible in Cpanel or Plesk).
+
+'''2)''' Choose the database where Dolphin is installed.
+
+'''3)''' Click the "SQL" tab at the top.
+
+'''4)''' Enter one of these queries:
+
+   '''a)''' For admin account creation:
+{{{
+INSERT INTO `Profiles` SET `NickName`='ADMIN_NICK', `Status`='Active', `Role`='3';
+UPDATE `Profiles` SET `Salt` = 'SALT_SEQUENCE' WHERE ID = last_insert_id();
+UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('ADMIN_PASSWORD'), `Salt`)) WHERE ID = last_insert_id();
+
+}}}
+   '''Note''': '''ADMIN_NICK''' should be replaced with the desired admin account name, '''ADMIN_PASSWORD''' should be replaced with the desired password, '''SALT_SEQUENCE''' should be replaced with any sequence of alphanumeric characters)
+
+   '''b)''' For admin password change:
+{{{
+UPDATE `Profiles` SET `Salt` = 'SALT_SEQUENCE' WHERE `NickName`='ADMIN_NICK';
+UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('ADMIN_PASSWORD'), `Salt`)), `Role` = '3' WHERE `NickName`='ADMIN_NICK';
+UPDATE `Profiles` SET `Role` = '3' WHERE `NickName`='ADMIN_NICK';
+
+}}}
+   '''Note''': '''ADMIN_NICK''' should be replaced with the desired admin account name, '''ADMIN_PASSWORD''' should be replaced with the desired password, '''SALT_SEQUENCE''' should be replaced with any sequence of alphanumeric characters)
+
+'''5)''' Clear the cache in your admin account or clear the contents of the folders '''''cache''''' and '''''cache_public''''' (except for the '''''.htaccess''''' file) through FTP.