有类似问题,贴上来看看对你有否帮助:
[function.mysql-connect]: Can't create TCP/IP socket (10106)
Trying to connect to mysql with PHP under windows XP pro.
The solution to this problem was for me to connect
.via named pipe (FIFO)
in the my.ini, I added this:
enable-named-pipe
and renamed localhost:
HOST=.
(just a dot) and not
HOST=localhost
which, if I anderstand well try to find its way via TCP/IP and for some reason doesn't.
I overlooked the installation manual.
Everything works just fine now.
[function.mysql-connect]: Can't create TCP/IP socket (10106)
Trying to connect to mysql with PHP under windows XP pro.
The solution to this problem was for me to connect
.via named pipe (FIFO)
in the my.ini, I added this:
enable-named-pipe
and renamed localhost:
HOST=.
(just a dot) and not
HOST=localhost
which, if I anderstand well try to find its way via TCP/IP and for some reason doesn't.
I overlooked the installation manual.
Everything works just fine now.
解决方案 »
- 遇到MYSQL的难题,不知哪位仁兄可以解决,谢谢!
- mysql 插入gzcompress后的数据总是 ‘x’,为什么
- 强行退出 SP
- delete from emp-status 提示-status 附近语法错误,我是要删除这个表里所有信息
- C API开发mysql客户端寻求帮助
- Linux下安装Mysql后,用windows2000连接不上,why?急急急急急急急急急急急急急急急急急急急急急急!
- 联合索引真的存在吗?
- 为什么会出错:mysql="select * from Bbs_User where User_Name="& request.form("Name")谢谢!
- mysql主从复制:Slave_IO_Running、Slave_SQL_Running都为Yes,但是不能同步,Last_IO_Error:2003和Last
- MYSQL 更新语句问题
- mysql的查询问题,有关select .... where ..in ()的
- mysql中大家用什么类型代替boolean类型。
up
我在配置myodbc时在servername选项中填了点(.)在my.ini中添加了enable-named-pipe
然后重启动了服务,就再也没有出现连不上的现象。
谢谢!