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.

3 min read

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.

4 min read

MySQL on the Cloud with AWS RDS

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

5 min read

Using PyMySQL: Python's MySQL Library

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

6 min read