Changing Joomla admin password in MySQL

If you have lost your site's administrator password, but have access to MySQL database, know that all is not lost!

Basta utilizar o seguinte comando:

Just use the following command:

UPDATE #__users SET password=MD5('your-new-password') WHERE username='admin';

Note that password value will not be setted to exactly your-new-password, but no the result of this function, applied to the MD5 function. which in this case gonna generate the sequence 100cfd43424fc38fc89cbe6d7d63e247. This avoid that passwords be stored as pure text, and makes harder to use for who could stole them. Further I may discuss more about this hash implementation.

That is no way to retrieve the password. Just to set a new one.