What are the different connections of MySql?
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


Named pipe or memory


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