Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a software(toad for mysql) to connect to my MySql database. We have to provide some data('username','password' etc) to this Software to connect database. There is a field known as 'connection type' and it has 6 options

TCP
SSL SSH
NAMED PIPE
MEMMORY
HTTP PROXY
HTTP TUNNEL

Anybody explain about connection type and this six options?

share|improve this question
add comment

migrated from stackoverflow.com Aug 9 '12 at 14:06

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 0 down vote accepted

These two are in your list

  • NAMED PIPE
  • MEMMORY

Are localized to the machine. i.e. do not use the network and thus are very safe

The others use a network

TCP - Simple connection protocol using IP. See this

HTTP PROXY, HTTP TUNNEL - Uses the HTTP protocol to get over the (sometimes) problems of firewalls and routers). Either get a computer on the firewal just to forward requests on or just encode the reequests on the HTTP protocol (web) so it can pass thru. Both use TCP below it.

SSL - Just encrypts the communiction and uses TCP forthe communication with the encrypted data.

SSH is built upon SSL but does the authentication bit.

TO OTHERS - I HAVE SIMPLIFIED IT A BIT BUT GAVE LINKS

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.