My notes, things I have learned, and documentation I have created.

$ echo -n “mysupersecretpassword” | md5sum
117a520adbd19eff51100215aa7a7fbf –

I had to use this to change the Joomla 3 password stored in a MySQL database that I forgot for the only account I had created.

MySQL> UPDATE wxyz_users SET PASSWORD=’117a520adbd19eff51100215aa7a7fbf’ WHERE username=’myadminaccount’;