linux-pages.com
... arcane linux knowledge collected over the eons, bit by bit ...
Currently viewing the tag: "drupal"
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 […]
… don’t know what drupal and drush are? Then this post is probably not for you…
Let’s face it – drush is a bitch to install. But we want it. So we have to. And install it we will!
Even though there appears to be extensive info on the topic on drush’s website, installing it […]
Assuming we all know how to check the drupal version if your site is online and you know the admin password… (Administer > Logs > Status Report)
But what do you do when you only got a zipped backup of your drupal site or the site is offline or you don’t have the admin password […]
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:
