Home

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;

Let's Connect

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.

Mar 09, 2015

WTF is Hoisting?

Sometimes JavaScript code appears to behave oddly. Hoisting is one of the reasons why. Here's an introduction to the concept, with references to more in-depth explorations.

Aug 07, 2020

How to Transition from CarrierWave to Dragonfly

It can be a process to move away from CarrierWave once you're already using it. Here's a step-by-step process to make it easy to transition to Dragonfly.

Jan 02, 2015