Mount remote directories with sshfs
Instructions for installing fuse based sshfs (ssh file system) on Debian based distros.
Create a MySQL Super User
A ‘super user’ in this context is set up for convenience and has full access to everything, the same as the MySQL root account.
Install MySQL on Mac OS X Mavericks
Instructions for installing MySQL and some helpers.
MySQL 5.5 – SQLSTATE[HY000]: General error: 23 Out of resource
ERROR 23 (HY000): Out of resources when opening file ‘/tmp/sometable.MYD’ This happened on a fresh Debian Testing install with only MySQL.
Enable Hibernate on Kubuntu 12.10
This was disabled from 12.04 (Precise Pangolin) as users were experiencing too many issues. Here’s how to re-enable.
Set MTU for VPN connection managed by NetworkManager daemon
Every time I connected to a Microsoft PPTP VPN server from Debian/Ubuntu desktop, I experienced slow network and dropped connections. Here’s how I fixed it.
SSH cheatsheet
Secure Shell (SSH) provides a secure channel to a remote server for command execution, file copy, tunnelling, etc., and is essential for administering those remote servers. SSH uses public key cryptography to encrypt communication via a public and private key. The private key must be kept secret by the sender and is used to encrypt data. The public key … [Read more…]