MySQL Database

Localhost 3306 Connection Error?

Port 3306 is the default port for MySQL. If you can't connect via Workbench or Terminal, check your service status.

Check Database Status
Kill Port 3306
npx kill-port 3306

Fixing MySQL "Can't connect to server"

The error Can't connect to MySQL server on 'localhost' (10061) usually means the service isn't running.

Step 1

Start the MySQL Service

Before trying to connect, ensure the daemon is active.

MacOS (Homebrew): 
brew services start mysql
Windows (CMD as Admin): 
net start mysql80

2. Check Port Bindings

If you have XAMPP or Docker running, they might have grabbed port 3306 first.

# Check what is using 3306
lsof -i :3306

Developer Port Reference Guide

Frontend & Web
3000 React / Node / Default 3001 React Secondary
Backend & Infrastructure
5000 Flask / AirPlay 4000 Jekyll / Hexo
Database & Cache
3306 MySQL 5432 PostgreSQL
DevOps & Data Science
8888 Jupyter Notebook 9200 Elasticsearch 9090 Prometheus 15672 RabbitMQ UI 8500 Consul 127.0.0.1 Loopback IP