Knowledge Base Article
Most scripts store their passwords in their databases. Therefore, this is the first place to look into when you wish to reset your administrative password. The databases can be managed by the phpMyAdmin tool available in your cPanel.
Usually, the table which contains the user information is called:
sometableprefix_users
The passwords are stored in an encrypted format, therefore, when you change them, you have to store them in the same encrypted format and not in plain text.
SugarCRM
If you can successfully log into the application with the 'admin' user, then simply click on the Admin link in the upper right of the application and then click on User Management to modify any user's display name and password.
If you do not remember that user's password, you will need to access the database directly and execute this SQL command.
update users set user_hash = md5('new_password') where user_name = 'admin';
You can execute the command using the phpMyAdmin tool -> SQL tab. Change the value new_password to whatever password you want.
Joomla/Mambo
Joomla/Mambo passwords are stored using a one-way MD5 hash which prevents recovering the password. But you can reset the password by editing the password field in the database. Set the password to a known value and then you may log in using that new password.
Open the database using the phpMyAdmin tool and browse the jos_users table. Find the user you want to change the password for and edit it (click on the pencil icon). In the password field choose the new desired password and from the Function drop-down menu choose MD5. Once you are ready, click on the GO button.
osCommerce
You can change your password at any time through your cPanel -> Password Protect Directories. Enter the new credentials you would like to use and click on the "Add/Modify User" button. (this works only on older osCommerce versions).
Rating
|

