MySQL administration via command line

When using MySQL on a Linux server, you’ll no doubt come into a situation where you’ll want to manipulate something via command line. Some of you will have tools like PHPMyAdmin installed, but you should always know a way to do things via command line.