mysql connect named pipe on windows

nyuszis · Post by **nyuszis** » 17.12.2011, 22:46

Hi!
I use Zdbconnection to connect mysql
please write example properties how to connect named pipe protocol to my server
mysql.exe connected to server right
any help is welcome

nyuszis · Post by **nyuszis** » 18.12.2011, 11:56

The Solution is next:
I change zdbcmysql.pas on line 457

Code: Select all

if FPlainDriver.RealConnect(FHandle, PChar(HostName), PChar(User),
PChar(Password), PChar(Database), Port, nil,
ClientFlag) = nil then

to

Code: Select all

if FPlainDriver.RealConnect(FHandle, PChar(HostName), PChar(User),
PChar(Password), PChar(Database), Port, 'MySQL',
ClientFlag) = nil then

If the HostName variable is '.' then connect to MySQL named pipe (it is default)
else connect TCP

thanks myself

papelhigienico · Post by **papelhigienico** » 18.12.2011, 13:05

And TCP/IP Connections, after this change, keeps the same behavior?

nyuszis · Post by **nyuszis** » 19.12.2011, 14:09

papelhigienico wrote:And TCP/IP Connections, after this change, keeps the same behavior?

The TCP/IP connect right if the HostName is the correct Computer name or ip and not '.'

papelhigienico · Post by **papelhigienico** » 19.12.2011, 20:53

What's your OS? Windows? I'm asking this because I don't have how test it on Windows, I can test this change only on Linux.

nyuszis · Post by **nyuszis** » 19.12.2011, 22:37

papelhigienico wrote:What's your OS? Windows? I'm asking this because I don't have how test it on Windows, I can test this change only on Linux.

Sorry, yes the os is Windows. And mysql run the next parameter:
--enable-named-pipe --socket=MySQL
The named pipe used only in localhost but the firewall not blocked the connection. Probably faster.

papelhigienico · Post by **papelhigienico** » 26.12.2011, 17:24

nyuszis, Can you see if this topic helps you: http://zeos.firmos.at/viewtopic.php?t=3318