This guide serves as the teaching notes and class curriculum for Class 5 of our LAMP Stack 101 Learning Track. Herein, we explore configuration and common housekeeping tasks performed from the MySQL command-line.
As is the case with all of our study guides, this classroom tutorial is a living document. It will be reviewed, and updated on a regular basis.
PRO TIP 1: Using This Guide
If you are using this tutorial on a live site, be sure to substitute any usernames and passwords used herein with your own unique values.
As of January 8, 2016, this guide has been thoroughly tested on MySQL Version 5.5.46 running on Ubuntu 14.04. To view your version run the following from the command line:
$ mysql -V
This will produce output similar to:
mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3