Last Updated: November 21, 2025
Database Operations
SHOW DATABASES;
List databases
CREATE DATABASE db;
Create database
USE db;
Switch to database
DROP DATABASE db;
Delete database
SHOW TABLES;
List tables in database
User Management
-- Create user
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
-- Grant privileges
GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
FLUSH PRIVILEGES;
-- Show grants
SHOW GRANTS FOR 'username'@'localhost';Backup & Restore
mysqldump -u user -p db > backup.sql
Backup database
mysql -u user -p db < backup.sql
Restore database
💡 Pro Tip:
Always backup before major changes!