MySQL Client and Connection Cheatsheet/Show connection status in the mysql client

Display host, connection id, server version, and current database.

Section: script-friendly client patterns

Show connection status in the mysql client

sql
sql
status
Explanation

Useful for verifying where you are connected before running risky statements.

Learn the surrounding workflow

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

Related commands

Same sheet · prioritizing script-friendly client patterns
Query without column headers
Print raw rows for scripts and pipelines.
OpenIn sheetbashsame section
Use batch mode for parsable output
Reduce formatting for machine-friendly results.
OpenIn sheetbashsame section
Log an interactive session to a file
Write statements and output to a transcript file.
OpenIn sheetsqlsame section
Show active sessions
Inspect current client connections and statements.
OpenIn sheetsqlsame section
Kill a running connection
Terminate a session by connection id.
OpenIn sheetsqlsame section
Connect to a local MySQL server
Open an interactive mysql session.
OpenIn sheetbash1 tag match