I completed the Relational Database Design and SQL Programming class at the UCSC Extension campus, but there’s always more to learn! That’s why I’m working through Sams Teach Yourself SQL in 24 Hours (5th Edition). I’ll be posting more detailed parts of my coursework on my GitHub, but I’ll share a few articles here. Firstly, it should come as no surprise that the textbook provides plenty of info for Windows and nothing for installing on Ubuntu. So, here are my notes from working through that install.

I followed the tutorial from Rackspace. As you may have noticed from my other articles, I was screenshotting a lot of the terminal outputs to write about. That’s been way to tedious, so I’m gonna try out a Markdown tool. As you may have read, I’m using Jekyll and GitHub pages to host this site, so Markdown is fully supported. This is my attempt at using the code snippet highlight feature from the Rogue wiki page. This is what I had to type into the terminal:

sudo apt-get update
sudo apt-get install mysql-server

And that was all it took! :) The mysql_secure_installation utility runs after install and that prompted me to set a default password and then I was up and running! Consider Hour 1 of the 24 hours to be done.

starting up mysql