Posted byRalph on March 2nd, 2017.
How to use Rsync with standard Amazon Web Services instances that utilise a .pem key file instead of traditional username/password authentication or conventional SSH key pairs: The standard AWS EC2 instances support using a .PEM key to log in, instead of a more common SSH username/password combination. If you want to use Rsync to transfer […]
Posted byRalph on August 31st, 2015.
1. Identify public IP address: 2. Edit /etc/mysql/my.cnf, replacing the value for bind-address, usually 127.0.0.1 with your public IP address derived above: 3. Type the following to enter the MySQL shell and provide your password: 4. Grant remote access to the desired MySQL user with the following command, replacing ‘root’ with the desired user and […]
Posted byRalph on February 2nd, 2015.
Like most server administrators, I find myself needing to analyse server logs for some reason. It’s pretty annoying when you view log files in an attempt to make sense of your data only to find the time-stamps on events don’t correspond to your local time.