SQL

Configure Relational databases, brush up on your query languages, or find third-party services to supercharge your data.

Accessing Self-Hosted MySQL Externally

Connecting to MySQL instances hosted on a VPS

In the previous post we got familiar with the basics of creating and navigating MySQL databases. This leads us to the next most logic thing to ask: how can I use this in any meaningful way?

MySQL installations default to refusing connections outside of the local machine's IP address, as we should expect. That said, relational databases aren't usually being

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Apr 22
Read

Setting up a MySQL Database on Ubuntu

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

As frameworks and services evolve to remove us further away from boilerplate code, the first casualty of saved time is the fundamental understanding of what we're actually doing sometimes. This has good reason; one can only learn so much from repetitive command-line interactions with databases, thus making any service's one-click-deploy button all the more sensible.  If I  had to imagine

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Apr 17
Read