Doc #61570 [Com]: mysqlnd cannot connect to MySQL when only named pipe is enabled
| From: | o dot g dot 67 at mail dot ru | 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