Port reference › Databases
Port 3306 · MySQL / MariaDB
MySQL and MariaDB
TCP Databases Exposure risk: High
What is port 3306 used for?
Default port for MySQL and MariaDB.
Registered port (1024-49151): the range used by ordinary applications.
Security notes
Never expose database ports. Allow only application server IPs and use an SSH tunnel for remote work. Check bind-address.
Allow port 3306 through the firewall
This port is risky to expose, so the commands below allow only the IPs you specify.
# Replace 203.0.113.10/32 with the IP or network you want to allow
sudo ufw allow from 203.0.113.10/32 to any port 3306 proto tcp
sudo ufw status # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo firewall-cmd --permanent --add-rich-rule='rule family="ipv4" source address="203.0.113.10/32" port port="3306" protocol="tcp" accept'
sudo firewall-cmd --reload # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo iptables -A INPUT -p tcp -s 203.0.113.10/32 --dport 3306 -j ACCEPT # Replace 203.0.113.10/32 with the IP or network you want to allow
New-NetFirewallRule -DisplayName "Allow TCP 3306" -Direction Inbound -Protocol TCP -LocalPort 3306 -RemoteAddress 203.0.113.10/32 -Action Allow # Replace sg-0123456789abcdef0 with your security group ID
aws ec2 authorize-security-group-ingress --group-id sg-0123456789abcdef0 --protocol tcp --port 3306 --cidr 203.0.113.10/32 Check whether port 3306 is open
sudo ss -tlpn | grep ':3306 ' netstat -ano | findstr :3306 nc -zv SERVER 3306
# Windows
Test-NetConnection SERVER -Port 3306 sudo lsof -i :3306