The incoming ports that need to be forwarded for MySQL Server are:
MySQL Server - PC
- TCP: 3306
- UDP: 3306
Forwarding Ports for MySQL Server
You may need to forward ports in your router when you use MySQL Server. Forwarding ports is used to allow incoming connection requests from the internet to MySQL Server.
By default routers do not allow incoming network requests. By forwarding ports you can work around this limitation.
Before Forwarding a Port
You need to know the following things before you can forward a port:
- Your router's IP address.
- The IP address of your computer.
- The list of the TCP and UDP ports that you need to forward.
How to Locate Your Router's IP Address
To find your router's IP address the easy way you can use our free Router Detector software. Our Router Detector tool is free to use and is part of our Network Utilities software.
You can also follow our Find Your Router IP Address article.
Setting Up a Port Forward for MySQL Server
The easiest way to forward your ports is to use our Network Utilities software. Network Utilities lets you manage port forwards by putting them in when you need them and also removing the ones that you no longer need which maximized network security.
You can also choose to set up port forwards manually. The process for forwarding a port is:
- Log in to your router.
- Look for the port forwarding section in your router.
- Put your computer's IP address in the proper box in your router.
- It is now time to type the TCP and UDP ports that you are forwarding for MySQL Server in the correct boxes in your router.
Usually you have to reboot your router in order to save the changes.
You can choose your router from our list to see exactly how to forward ports for MySQL Server:
List of Routers - Customized for MySQL Server
Those are the steps to take in order to forward ports in your router for MySQL Server.