Assuming that a) using the email to request the new password isn’t an option AND b) you have access to mysql or phpMyAdmin you may use the following methods to recover the password for your drupal root user: drupal 6: In drupal 6 the password is stored as a simple MD5 hash of your plain […]
1. Edit file /etc/my.cnf.d/mariadb-server.cnf and add these 3 lines to the [mysqld] section: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true This will enable usage of Multi-byte (in particular – 4-byte) UTF-8 support in Drupal 7. 2. mysqli: If you have problems with mysqli/mysql change the mysqli to mysql (or vice versa – whatever works for you) in /sites/default/settings.php. Alternatively […]
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 […]
… copied as-is from : http://fedorasolved.org/server-solutions/lamp-stack Very useful info, everything works like a charm (I tried on FC15) so I am replicating this here in case that page ever gets archived, goes offline, etc. I will see if I can add some more info about setting phpMyAdmin here as well. Doing the work The best […]