List databases

sql

SHOW DATABASES;

Explanation

Visibility depends on privileges.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing mysql client basics

Display tables in the selected schema.

Open In sheetsqlsame section

Open an interactive mysql session.

Open In sheetbashsame section

Specify the host, port, user, and prompt for a password.

Open In sheetbashsame section

Open mysql and select the target schema immediately.

Open In sheetbashsame section

Execute a SQL statement non-interactively.

Open In sheetbashsame section

Set the active database for subsequent statements.

Open In sheetsqlsame section