© 2015 X2Engine Inc.
Difference between revisions of "Manually Resetting Passwords"
From X2Engine
Line 12: | Line 12: | ||
To reset the password: | To reset the password: | ||
# Come up with a new secure password and make note of it. | # Come up with a new secure password and make note of it. | ||
− | # Generate an | + | # Generate an MD5 hash of the new password, if an MD5 tool is available. Otherwise, the string <tt>5f4dcc3b5aa765d61d8327deb882cf99</tt> can be used (it is the MD5 digest of "password" in all lower-case). |
# Log into the database. | # Log into the database. | ||
− | # Set the "password" field in the users table to the new | + | # Set the "password" field in the users table to the new MD5 hash on the admin user, i.e. to set it to lowercase "password" for user "admin": <syntaxhighlight lang="mysql">UPDATE x2_users SET password='5f4dcc3b5aa765d61d8327deb882cf99' WHERE username='admin';</syntaxhighlight> |
# If "password" was used as the password, log in immediately as the administrator and change the password to the new password. | # If "password" was used as the password, log in immediately as the administrator and change the password to the new password. |
Revision as of 18:55, 25 January 2013
These instructions are for the case where the web application's administrator's password has been lost. If this is not the case, and one can log in to X2CRM as an administrator, changing any user's password can be done as follows:
- Log in as the X2CRM administrator.
- Go to the "Users" module by following the link in the user menuThe menu accessed by clicking on one's own username in the far upper-right-hand corner of the application. (it should be found it near the search field in the top bar).
- Click on the user, and then click "update"
- Enter a new password into the Password field.
If, on the other hand, one does not have the administrator password, it can be reset, but requires the following:
- Direct access to the database using PHPMyAdmin or some other means
- (optionally) a software tool for generating MD5 hashes
To reset the password:
- Come up with a new secure password and make note of it.
- Generate an MD5 hash of the new password, if an MD5 tool is available. Otherwise, the string 5f4dcc3b5aa765d61d8327deb882cf99 can be used (it is the MD5 digest of "password" in all lower-case).
- Log into the database.
- Set the "password" field in the users table to the new MD5 hash on the admin user, i.e. to set it to lowercase "password" for user "admin":
UPDATE x2_users SET password='5f4dcc3b5aa765d61d8327deb882cf99' WHERE username='admin';
- If "password" was used as the password, log in immediately as the administrator and change the password to the new password.