Reset a lost MySQL root password

The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.

Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to the Server.

Not the Server root user

A common issue is confusing the Server root user with the MySQL root user. Continue reading “Reset a lost MySQL root password”

AWS Backups

Since AWS is entirely self-managed, it’s up to you to keep your instance updated and secure. That’s a lot of responsibility, so I recommend setting up a calendar alert on your phone and/or computer so that you go through the motions at least once a month.

Backups in AWS are surprisingly simple. To create a backup, you simply make a “Snapshot” of your instance.

1) Log into your AWS Console
2) Go to your EC2 dashboard
3) Go to your Volumes tab.
Continue reading “AWS Backups”