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?
Jack_son_Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
InsoftserviceConnect With a Mentor Commented:
3306  is default port for mysql. while connecting these two servers you could provide the correct hostname to the server
0
 
rpkhareConnect With a Mentor Commented:
When you install MySQL, it automatically chooses a port. You should keep the one it configures while installing.
0
 
DamjanConnect With a Mentor Commented:
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 PaseurConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.