Working with MySQL

Working with MySQL

Get comfortable with your MySQL lock-in by covering general topics related to running your own MySQL database. Learn to initialize a MySQL database and configure it to be externally accessible by other services. Explore options for cloud-hosted MySQL instances such as AWS RDS.

What You'll Learn

Run self-hosted MySQL by installing and initializing on Ubuntu.
Configure a MySQL instance to be secure over a network.
The pros and cons of managed relational databases.
Useful Python code for interacting with data in MySQL.

For those who...

Have no choice but to use MySQL
Would like to save money by managing their own MySQL database

Setting up a MySQL Database on Ubuntu

Setting up MySQL the old-fashioned way: on a Linux server.

Accessing Self-Hosted MySQL Externally

Configure a self-installation of MySQL on Ubuntu to allow access from external sources, such as SequelPro or other GUIs.

MySQL on the Cloud with AWS RDS

The layman's guide to configuring & working with MySQL databases with AWS RDS (Relational Database Service)

Using PyMySQL: Python's MySQL Library

Connect and fetch records from a MySQL Database using Python's lightweight PyMySQL library.