List All Databases on MySQL Server
It's not that hard, but I keep forgetting how to do it, so I wrote it down.
It's pretty simple, but something I've found myself looking for this a few times recently. Log into mysql as you normally would.
$ mysql -uroot -proot
This will give you the mysql prompt, at which you can enter:
mysql> SHOW DATABASES;
And you'll get your listing of databases! Make sure you use a semicolon to end that statement. It's easy to get caught up wondering why your command isn't executing.
Also, note you may use lower case here. In other words, this will work, too:
mysql> show databases;
Keep Reading
Connect to a Remote MySQL Database in Rails
Using a remote database with rails is useful for collaborating on projects or for keeping all your data in one place. Here's how to get it set up from scratch.
Generate Meta Images for Blog Posts with Node.js
Manually creating images for blog posts can be super time-consuming. Here's the foundation necessary for automatically generating meta images for content in markdown files.
The Best Thing about Jamstack
In exploring the artifacts of the early Jamstack movement, I’ve come to discover the best part of the Jamstack. This now guides how I describe Jamstack.