my dog learned polymorphism*
The moose likes JDBC and the fly likes What is mysql ports ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "What is mysql ports ?" Watch "What is mysql ports ?" New topic
Author

What is mysql ports ?

nid kumar
Greenhorn

Joined: Nov 02, 2011
Posts: 2
Please tell that what is mysql ports ? and what is its role in mysql ?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

What makes you think that "mysql ports" is something? Did somebody tell you to use it, or them, or what?
Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

Is this what you are looking for?
http://www.herongyang.com/JDBC/MySQL-JDBC-Driver-Connection-URL.html
3306?


[uaiHebert.com] [Full WebApplication JSF EJB JPA JAAS with source code to download] One Table Per SubClass [Web/JSF]
nid kumar
Greenhorn

Joined: Nov 02, 2011
Posts: 2
Hebert Coelho wrote:Is this what you are looking for?
http://www.herongyang.com/JDBC/MySQL-JDBC-Driver-Connection-URL.html
3306?

Can you please tell what is" mysql ports" ?
hemantha kumar k
Greenhorn

Joined: Apr 20, 2010
Posts: 27

You have to understand about "port" not about "mysql Port"?

let me tell you one story about post card

let say in you home three people are living, you, your dad, and your mom
now three for you living in one home,
if one post card come to you then address on the post card consists of your home address and your name
if one post card come to your dad then address on the post card consists of your home address and your dad name
if one post card come to your mom then address on the post card consists of your home address and your mom name

when any of the above post card reach to postman then he has two works
1. he has to locate your home
2. he has to handover the post card to one who's name which has been mentioned on the post card.

Even though three people living in the single home, post man will delver to the specific person on your home by the help of Name on the post card

when it comes to computer, n number of computer application runs on the single computer, then how you'll find which one you want to deal with?
there your port number comes in picture, for each application running on your computer a unique logical number will be given, by using with that unique number you'll interact with the specific application on your computer.

lets say you installed the tomcat web server and install the mysql database server on your computer, now you want to interact with the tomcat server how you'll do?
you will write "localhost:8080" and if you want to interact with the mysql the u'll write "localhost:33036" here u'll find two thing one is "localhost" which means your computer, and two distinct number for two different application, means what two application living on the same computer , and if you want to interact with the specific application then you'll use specific logical name(port address) of that application.

so in simple word port number is the unique logical number, which will be given to represent the specific application on a computer.

I hope this will help you

Vinod Vijay
Ranch Hand

Joined: Sep 13, 2011
Posts: 137

Don't know about the user but I have understand very well.
Thanks a lot


Vinod Vijay Nair
Aniket S. Kulkarni
Ranch Hand

Joined: Jun 15, 2011
Posts: 87

@tinku rider:Thanks!!!
This is the best post for explaining "What is port?"
You explained in great detail.


Aniket Kulkarni
Oracle Certified Professional, Java SE 6 Programmer.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What is mysql ports ?