Joomla 3 Encrypt Passwords for Database Methods

New Issue

Joomla Support Stella 10 Mar 2018

(1 Ratings)

I would like to know if it is possible to take a unencrypted password in Joomla, and then convert it to an encrypted password that Joomla 3.6.5 will understand after it has been directly inserted into the database via MySQL?

Thanks in advance!

1 Responses

AppClave

6 years ago #189

Hi,

You can just use MySQL's MD5 function - Joomla understands passwords that are hashed using MD5. No need to create a any script.

In phpMyAdmin, find table #__users table, here just change the password to the one that you want and choose MD5 from the function dropdown.

1. Once you were in #__users table table, then 'Edit' link on which user row you want to going to make change in password

2. In 'password' column, change the 'Function' to 'MD5' and in 'Value' field enter your password like in screenshot attached

Best Regards
AppClave Team

Reply