Home → Problems →

Mysql connection via named pipe

• Edit

aikorsky

Oct 13, 2016 @ 09:08 AM

Hello.

I can't connect to mysql server via named pipe.
OS returns "The system cannot find the file specified. (os error 2)".
Pipe name was taken from @@socket variable of running mysql instance so i hope it is correct.
Also this problem does not appear on my local machine.

Here is the build logs: https://ci.appveyor.com/project/blackbeam/rust-mysql-simple/build/job/h637o4slcedn3jj8

Is there a way to fix this?

1. 1 Posted by Ilya Finkelshte... on Oct 13, 2016 @ 10:23 PM

   

   Hello,

   I believe that problem is because named pipes are not enabled by default in standard MySQL installation. Please add the following (or equivalent if you do not like PowerShell) at install stage or anywhere before your tests.

   - ps: >-
       $iniPath="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini"
   
       $newText = ([System.IO.File]::ReadAllText($iniPath)).Replace("# enable-named-pipe", "enable-named-pipe")
   
       [System.IO.File]::WriteAllText($iniPath, $newText)
   
       Restart-Service MySQL57
   

   Please let us know if this helps.

   --ilya.

   • Edit

2. 2 Posted by aikorsky on Oct 14, 2016 @ 07:24 AM

   

   It works!
   Thanks a lot, Ilya.

   • Edit

3. Ilya Finkelshteyn closed this discussion on Aug 25, 2018 @ 02:09 AM.