Page 1 of 1
mysql connect named pipe on windows
Posted: 17.12.2011, 22:46
by nyuszis
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
Posted: 18.12.2011, 11:56
by nyuszis
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
Posted: 18.12.2011, 13:05
by papelhigienico
And TCP/IP Connections, after this change, keeps the same behavior?
Posted: 19.12.2011, 14:09
by nyuszis
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 '.'
Posted: 19.12.2011, 20:53
by papelhigienico
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.
Posted: 19.12.2011, 22:37
by nyuszis
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.
Posted: 26.12.2011, 17:24
by papelhigienico
nyuszis, Can you see if this topic helps you:
http://zeos.firmos.at/viewtopic.php?t=3318