Doc #61570 [Com]: mysqlnd cannot connect to MySQL when only named pipe is enabled

From: Date: Thu, 20 Nov 2014 11:14:08 +0000
Subject: Doc #61570 [Com]: mysqlnd cannot connect to MySQL when only named pipe is enabled
References: 1  Groups: php.doc.bugs 
Request: Send a blank email to doc-bugs+get-11682@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=61570&edit=1 ID: 61570 Comment by: o dot g dot 67 at mail dot ru Reported by: peaceable_whale at hotmail dot com Summary: mysqlnd cannot connect to MySQL when only named pipe is enabled Status: Open Type: Documentation Problem Package: mysql Operating System: Windows Server 2008 R2 PHP Version: 5.4.1 Block user comment: N Private report: N New Comment: ====more complete instructions to solve this problem on windows platform==== ============================================================================ in file <php.ini>, or another config php files if use, need follower: mysql.default_socket= mysqli.default_socket= in file <my.ini>, or another config mysql files if use, need follower: socket = mysql ============================================================================ It's all :) Previous Comments: ------------------------------------------------------------------------ [2014-11-20 03:31:03] o dot g dot 67 at mail dot ru sorry, "this problem" :) change need make in file <php.ini> ------------------------------------------------------------------------ [2014-11-20 03:04:33] o dot g dot 67 at mail dot ru I have this problev when <mysqli.default_socket="mysql"> and use msqli. To solve need cleanup this parameter <mysqli.default_socket=> ------------------------------------------------------------------------ [2012-06-14 12:12:58] uw@php.net Thanks for following up and changing to doc problem. Great hint on open basedir... mysqlnd is using PHP Streams and PHP Stream will follow PHP rules. ------------------------------------------------------------------------ [2012-05-04 10:18:29] peaceable_whale at hotmail dot com Finally, I found that the connection problem is caused by the use of open_basedir. It appears that named pipe cannot be used with open_basedir. I have changed the type of this report to be documentation problem. I think the documentation should mention that: - "." should be used instead of "localhost" for named pipe connection - Named pipe will fail when open_basedir is in effect ------------------------------------------------------------------------ [2012-05-04 08:49:14] peaceable_whale at hotmail dot com Yes, I am able to connect using the following command: mysql -W -u root -p ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=61570 -- Edit this bug report at https://bugs.php.net/bug.php?id=61570&edit=1

« previous php.doc.bugs (#11682) next »