Tag: linux
-
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 simple feature in the dashboard to enable Basic Authentication for an entire website domain. It cannot, however, do this for just a specific subdirectory (or…
-
Howto create a MariaDB database and user with UTF8mb4
Reference
-
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 can use the Linux command line SCP directly from Windows: You can use this shortcut if you’ve already setup your SSH agent. There is unexplained…
-
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 files stored in Google Photos/Drive and the otherwise excellent dupeGuru simply didn’t show the OnePlus 3 as a possible target for scanning. I ended up…
-
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 line. The solution is to list all currently running MariaDB processes, which call themselves ‘mysql’ for compatibility with MySQL: This will output some results, such…