31,029
edits
FAQ I Lost my password: Difference between revisions
Jump to navigation
Jump to search
m
→If the lost password is that of the Dolibarr admin account
m (Eldy moved page FAQ I Lost my database password to FAQ I Lost my password) |
Tag: 2017 source edit |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
<!-- You can edit this section but do NOT remove these comments | <!-- You can edit this section but do NOT remove these comments | ||
Links below will be automatically replicated on translated pages by PolyglotBot --> | Links below will be automatically replicated on translated pages by PolyglotBot --> | ||
[[fr: | [[fr:FAQ J'ai perdu mon mot de passe]] | ||
[[es: | [[es:FAQ Tengo un problema en la contraseña]] | ||
<!-- END interlang links --> | <!-- END interlang links --> | ||
| Line 139: | Line 139: | ||
Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect. | Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect. | ||
<syntaxHighlight lang="sql"> | <syntaxHighlight lang="sql"> | ||
mysql> USE nomdelabaseolibar | mysql> USE nomdelabaseolibar; | ||
mysql> UPDATE llx_user SET pass = 'atemporarypasswod' WHERE login ='loginuserbloque'; | mysql> UPDATE llx_user SET pass = 'atemporarypasswod' WHERE login ='loginuserbloque'; | ||
</syntaxHighlight> | </syntaxHighlight> | ||
Try to connect then modify your password from your user profile. This will clear the unencrypted temporary password in order to store your new encrypted password in this table. | Try to connect then modify your password from your user profile. This will clear the unencrypted temporary password in order to store your new encrypted password in this table. | ||