MySQL offers many ways (on Windows) to connect to it, those are:
My question is, if MySQL will be run on the same machine of the web server, then which method is best for security and performance?
P.S. This is a one web server scenario, no web farm.
Thanks
I'd say named pipes as it does provide significant difference than TCP/IP (tested with large dump imported).
But you might need to consider how the actual application on the web server will perform using any of these connections, because the driver might not be capable of working with named pipes for example.
I had problems with php (on windows) and named pipes so you'd need to check that part of the story as well.