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

The rest of this content is only available to registered users