MySQL Backup 1.2 (MySQL 5.5+)

In the previous versions of this script you’ve had to leave the backup user password in the script, however MySQL 5.5 and above come with mysql_config_editor which allows you to store connection details in an ancryptedl file (~/.mylogin.cnf) which mysql/mysqldump/mysqladmin can use with the “–login-path=” option. For basic usage run the following, the –password prompts … [Read more…]

Using Google Authenticator with more than one device

Ok, so if you’re using Google Authenticator to protect logins on servers or just for your own Google mail / apps login you may come across the situation where you want it on more than one device. For example I’ve an Android phone and a tablet, and sometimes the phone is like really far…. like … [Read more…]

Admin Training

How to be a Linux sys-admin in one easy lesson, just memorise these phrases and use at random No chance. You’ll not get that today Kill All Developers Do you have a ticket for that? Simple!

Passwordless SSH

There are many times where it would be preferable to authenticate to a server without having to enter a password. Basically any time you want to transfer things between servers with scripts you’ll need to be able to authenticate as a valid user. The best way to do this is with SSH keypairs. In this … [Read more…]