[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

MySQL Port Question

If I have a back end server with a MYSql database and then a front end server with a php application, which ports do I open to configure communication between the two servers?  Just 3306, or should there be others?
0
Jack_son_
Asked:
Jack_son_
4 Solutions
 
rpkhareCommented:
When you install MySQL, it automatically chooses a port. You should keep the one it configures while installing.
0
 
DamjanCommented:
To communicate witch MySQL server you need to open only port 3306 (default). For security reasons allow MySQL server access from your web server only.
0
 
Ray PaseurCommented:
It's almost always 3306.  There may be others for clusters, etc.  This (slow to load) document has a canonical list:
http://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xml
0
 
InsoftserviceCommented:
3306  is default port for mysql. while connecting these two servers you could provide the correct hostname to the server
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now