Tools
MySQL Cheat Sheet
Print-ready cheat sheet for MySQL, organized for fast lookup, study, and desk-side use
Sample
What's in this cheat sheet
- Connecting
- Databases & Tables
- Data Types
- CRUD
- Joins
- Indexes
- Functions
- Users & Permissions
- Backup & Restore
- Common Patterns
Command Line
mysql -u root -p
mysql -u user -p -h 127.0.0.1 -P 3306
mysql -u user -p mydb < dump.sql
Connection String
mysql://user:password@host:3306/dbname
mysql -u user -p -e "SELECT VERSION();"
Status Commands
STATUS;
SHOW VARIABLES LIKE 'port';
SHOW PROCESSLIST;
Download the full cheat sheet for all sections, formatted for print
Download PDFDownloads
Choose the treatment that matches how you read
-
Recommended
Standard
B&W, ink-efficient. The default for laser printers and photocopies
Best for Printouts and desk-side reference
-
Color
Warm color accents for on-screen reading or color printers
Best for Screen reading or color printers
-
Reference Card
Maximum density, 4-column layout. Everything on one page
Best for Fast scanning and minimum paper use
