Adding Basic Authentication to a Subdirectory on SpinupWP
SpinupWP is a great hosting platform for people who want to own their own cloud servers, but not have to worry about running a web stack. It also has a […]
linux
Howto create a MariaDB database and user with UTF8mb4
CREATE DATABASE databasename DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; GRANT ALL ON database_user.* TO ‘database_user’@’localhost’ IDENTIFIED BY ‘database_user_password_max_41_characters_’; Reference https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/ https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-lemp-on-ubuntu-16-04
How to download a file from a remote Linux server via SCP in Windows using Cmder
If you’re working on Windows and you need to grab a file from a remote Linux server over SSH, make sure you use Cmder. Once you have Cmder extracted, you […]
Android, MTP and Windows programs
It’s frustrating how many older Windows programs handle MTP – they simply pretend it doesn’t exist. I wanted to dedupe some photos and videos between my OnePlus 3 and the […]
How to manually kill a MariaDB process
Thanks to Wojtek Dmyszewicz on StackOverflow for saving me time and frustration when I ran into [ERROR] InnoDB: Unable to lock ./ibdata1, error while working with MariaDB at the command […]