Best Ubuntu Command Prompt

There are lots of tutorials on the internet defining what the best Ubuntu command prompt is, and I’ve worked through a lot of them. They all seem to have a similar format: username, then the folder you’re in (some also add the time, the history number of...

Setting up SFTP on Ubuntu

Let’s start at the beginning; why sftp? Well, would you transmit your private details (including your password) in plain text? No? Well, FTP does. FTP is one of several protocols on a computer that transmits usernames and passwords in plain text across the...
Resetting the MySQL Root Password

Resetting the MySQL Root Password

One of a short series of posts listing useful MySQL commands that I use frequently when managing servers and databases. These come in useful when I don’t have access to Navicat, my favored tool for working with client databases. The assumption I make is that you...