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 […]
To make your web-page fonts increase/decrease as the browser window dimensions change use viewport-based values instead of %, ems, pxs or pts. 1vw = 1% of viewport width 1vh = 1% of viewport height 1vmax = 1vw or 1vh, whichever is larger 1vmin = 1vw or 1vh, whichever is smaller Example: h1 { font-size: 4vw; […]
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 […]
Problem: A site contains data which is of interest to us. The data is uniformly structured and available for examination by the general public (i.e. no login required) but is not automatically accessible, i.e. viewing it requires repetitive user interaction (such as setting a date range, clicking a ‘submit’ button, etc). In addition, usually the […]
… 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 […]
Scenario —————————————————————— You are maintaining several web-sites (site1.com, site2.org, etc…). Having just one web-site at localhost with all files (DocumentRoot) at /var/www/html is not an option for you. You need to be able to test all of them and to access them in a convenient way. Solution Setup apache with Virtual Hosts, give your sites […]
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: 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 […]