Cheat Sheet logoCheat Sheet Today
MySQL Client and Connection Cheatsheet/Connect directly to a database

Open mysql and select the target schema immediately.

Back to sheetBrowse commands
Sign in to save
Section: mysql client basics

Connect directly to a database

bash
bash
mysql -u app_user -p app_db
Explanation

Equivalent to connecting first and then running `USE app_db;`.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing mysql client basics
Connect to a local MySQL server
Open an interactive mysql session.
OpenIn sheetbashsame section
Connect to a remote host and port
Specify the host, port, user, and prompt for a password.
OpenIn sheetbashsame section
Run one query and exit
Execute a SQL statement non-interactively.
OpenIn sheetbashsame section
Select a database
Set the active database for subsequent statements.
OpenIn sheetsqlsame section
List databases
Display all databases visible to the current account.
OpenIn sheetsqlsame section
List tables in the current database
Display tables in the selected schema.
OpenIn sheetsqlsame section