Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Solved
MySQL Port Question
Posted on 2012-12-29
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
When you install MySQL, it automatically chooses a port. You should keep the one it configures while installing.
Active today
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.
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
http://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xml
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month9 days, 23 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.