Protocol property

Top  Previous  Next

See Also Properties Methods Events Example

Unit

MySQLServer

 

Applies to

TMySQLServer component

 

Declaration

TMySQLProtocolType = (ptTCP,ptPipe);

property Protocol: TMySQLProtocolType default ptTCP;

 

Description

Set or Get the current protocol used for the connection to the MySQL server, typically this is ptTCP by default.  However, in certain environments can ptPipe be used if your application and the MySQL server is running on the same physical machine.  Pipe communication, in general, is always switched on for a MySQL server and also offers a much faster connection, as it does not come with the overhead of TCP/IP stack.  If you pick ptPipe, should you change your Host property to reflect the MySQL pipe name instead of the tcp/ip hostname, ex. in the format "\\Host\pipe\pipename", for example "\\.\pipe\MySQL" or "\\localhost\pipe\MySQL". For convenience does the TMySQLServer automatically replace a "localhost" or empty Host value with "\\.\pipe\MySQL" if you neglected to change it yourself.