Techno-babble for the Masses!
Ralph on April 12th, 2017.
Here are the commands you need to execute to change a forgotten MySQL root user password: Step # 1 : Stop the MySQL service: Step # 2: Start the MySQL server w/o password: Step # 3: Connect to the MySQL server using the MySQL client: Step # 4: Set a new MySQL root user password: […]
Ralph 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 […]
Ralph 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 […]
Ralph 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.