How-To · Database

Database guides

MySQL, Postgres, SQLite — install, errors, queries.

3 guides

MySQL Error 2002 (HY000) 'Can't connect to localhost (10061)' — 7 Fixes (2026)

Error 2002 means your client can't reach the MySQL server — service is down, port is wrong, socket file is missing, or firewall is blocking. Here are the 7 things to check, in order.

Jan 24, 2025 5 min read any intermediate

How to Check MySQL Version on Windows (2026) — CLI, Workbench, SQL Query

Three ways to check what MySQL version you're running on Windows — `mysql --version` from CLI, `SELECT VERSION()` from inside a query, or the GUI in MySQL Workbench.

Jan 24, 2025 3 min read windows beginner

'mysql is not recognized as an internal or external command' — How to Fix on Windows (2026)

Windows can't find mysql.exe because its bin directory isn't in PATH. Here's the quickest fix, plus the careful version for when the quick fix doesn't take.

Jan 15, 2025 8 min read windows beginner

Get weekly notes in your inbox

Practical tips, tutorials and resources. No spam.