MySQL Client and Connection Cheatsheet/Log an interactive session to a file

Write statements and output to a transcript file.

Section: script-friendly client patterns

Log an interactive session to a file

sql
sql
tee /tmp/mysql-session.log
Explanation

Inside the mysql client, `tee` starts recording output; `notee` turns it off.

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
Show connection status in the mysql client
Display host, connection id, server version, and current database.
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