Skip to main content

MySQL Client Cheat Sheet 2026 — Quick CLI Command Reference

2 min read

MySQL Client Cheat Sheet 2026 — Quick Command Reference

MySQL Client Cheat Sheet is the complete quick-reference of MySQL Client commands grouped by function. Copy any command with one click and find what you need with Ctrl+F in under 3 seconds.

MySQL Client Commands

Action Command Useful flags
Connect to a database 
mysql <database_name>
Connect to a database, user will be prompted for a password 
mysql --user <user> --password <database_name>
 --user --password
Connect to a database on another host 
mysql --host <database_host> <database_name>
 --host
Connect to a database through a Unix socket 
mysql --socket <path/to/socket.sock>
 --socket
Execute SQL statements in a script file (batch file) 
mysql --execute "source <filename.sql>" <database_name>
 --execute
Restore a database from a backup created with `mysqldump` (user will be prompted 
mysql < <path/to/backup.sql> --user <user> --password <database_name>
 --user --password
Restore all databases from a backup (user will be prompted for a password) 
mysql < <path/to/backup.sql> --user <user> --password
 --user --password

⚠️ Dangerous / Destructive Commands

These commands are irreversible. Verify your environment (dev/staging vs prod) before running them.

Action Command Warning
⚠️ Destroy ⚠️ 
terraform destroy -auto-approve
 Irreversible — verify the target before running
⚠️ Delete 
kubectl delete namespace production
 Irreversible — verify the target before running
⚠️ Prune ⚠️ 
docker system prune -af --volumes
 Irreversible — verify the target before running
⚠️ Delete 
pvesh delete /nodes/{node}/qemu/{vmid}
 Irreversible — verify the target before running
⚠️ Delete 
az group delete --name MyResourceGroup --yes
 Irreversible — verify the target before running

FAQ — Frequently Asked Questions

What is the difference between MySQL Client Commands and the other groups?

Each group in this MySQL Client cheat sheet covers a distinct area. MySQL Client Commands focuses on its specific scope, while the other groups and the remaining groups cover networking, storage, security and diagnostics respectively.

How do I check the installed MySQL Client version?

Run the version command (usually mysql version or mysql --version). The output shows the client and, when applicable, the server version.

Why does MySQL Client return ‘permission denied’?

A ‘permission denied’ error in MySQL Client usually means the current user lacks sufficient privileges or credentials are not configured. Check: (1) assigned IAM/RBAC roles, (2) an active authentication context via the corresponding login command.

How do I filter MySQL Client output by status or name?

Use flags such as --filter, --selector or --query depending on the tool. You can also pipe into grep or jq to process JSON: 

mysql list | grep RUNNING

What is the fastest way to debug a MySQL Client error?

Add the verbose flag (--verbose, -v or --debug) to the failing command. This reveals the underlying HTTP/API calls and the full error response body.

Official sources & references

Commands cross-checked against vendor documentation and high-authority repositories: