Do you have a password-protected spreadsheet and need to remove the password from it? Yes? Then this post will be helpful to you. There are some posts on the net suggesting that you can just open the .xls file as a zip archive and then edit the contents but I was unable to do that […]
There’s various articles and tutorials on the web explaining how to reset your WordPress password using different methods (email, ftp, emergency scripts, mysql, phpmydamin). Unfortunately a large portion of them, particularly the ones using mysql and phpmyadmin to reset the wordpress password will not work. Or rather – they will work but there is a […]
Recovering lost user (admin) password [ src: https://www.drupal.org/node/44164 ] Drupal 6 UPDATE users SET pass = MD5(‘givememypasswordback’) WHERE uid=1; Drupal 7 php ./scripts/password-hash.sh newpwd The script will output a password hash that is valid for the site, something like: $S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML Use it in a SQL query to set new passwd: UPDATE users SET pass =’$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML’ […]
Recovering your phpMyAdmin/mysql lost root login password How do you reset your mysqld and phpAdminPassword? First we need to change the mysql root password (or set to empty if we want to allow a passwordless login). After that we will setup phpMyAdmin to use this mysql login. 1. On newer Linuxes, e.g. Ubuntu 16.04 LTS […]