| 105 | |
| 106 | ---- |
| 107 | |
| 108 | == '''''How can I change admin username and/or password if I forgot it?''''' == |
| 109 | |
| 110 | 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). |
| 111 | |
| 112 | '''1)''' Log into your '''phpMyAdmin''' page (should be accessible in Cpanel or Plesk). |
| 113 | |
| 114 | '''2)''' Choose the database where Dolphin is installed. |
| 115 | |
| 116 | '''3)''' Click the "SQL" tab at the top. |
| 117 | |
| 118 | '''4)''' Enter one of these queries: |
| 119 | |
| 120 | '''a)''' For admin account creation: |
| 121 | {{{ |
| 122 | INSERT INTO `Profiles` SET `NickName`='ADMIN_NICK', `Status`='Active', `Role`='3'; |
| 123 | UPDATE `Profiles` SET `Salt` = 'SALT_SEQUENCE' WHERE ID = last_insert_id(); |
| 124 | UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('ADMIN_PASSWORD'), `Salt`)) WHERE ID = last_insert_id(); |
| 125 | |
| 126 | }}} |
| 127 | '''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) |
| 128 | |
| 129 | '''b)''' For admin password change: |
| 130 | {{{ |
| 131 | UPDATE `Profiles` SET `Salt` = 'SALT_SEQUENCE' WHERE `NickName`='ADMIN_NICK'; |
| 132 | UPDATE `Profiles` SET `Password` = SHA1(CONCAT(MD5('ADMIN_PASSWORD'), `Salt`)), `Role` = '3' WHERE `NickName`='ADMIN_NICK'; |
| 133 | UPDATE `Profiles` SET `Role` = '3' WHERE `NickName`='ADMIN_NICK'; |
| 134 | |
| 135 | }}} |
| 136 | '''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) |
| 137 | |
| 138 | '''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. |