How to convert lossless PNG to lossless WEBP via macOS terminal
Install libwebp first: Convert all the PNGs to WEBP and touch them to have the same datetime as the original PNG files. Then delete the original PNG files. Putting it […]
Convert a BIN+CUE CD image to ISO in macOS
TL;DR Download and extract poweriso to the user binary directory. curl -o temp-download-delete http://www.poweriso.com/poweriso-1.3-osx.tar.gz && tar -xvzf temp-download-delete -C /usr/local/bin/ && rm temp-download-delete Convert the BIN+CUE to a single ISO […]
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 […]
Hashcheck – the best way to calculate and verify checksums on Windows
HashCheck is the quickest and easiest way to verify downloaded files on Windows. Originally developed at code.kliu.org, HashCheck was left to languish for since 2009 until @gurnec took over stewardship […]
SSH keygen best practice for cmder
Bang this into cmder. mkdir %CMDER_ROOT%\config\.ssh and then this ssh-keygen -o -a 100 -t ed25519 -f %CMDER_ROOT%\config\.ssh\id_ed25519 Which will output something like this: Generating public/private ed25519 key pair. Enter passphrase […]
SSH without passwords in Windows using cmder
Being able to log into remote servers without remembering each unique password is one of the great things about the public-key system. In Linux this is pretty much expected behaviour, […]
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 […]
Configuring the Red Scarf III 84 (RS84) keyboard layout
I have been envious of the neatness of my friend’s 60% keyboards for some years. I’ve also liked the idea of taking up less desk space and minimising the amount […]
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 […]