有类似问题,贴上来看看对你有否帮助:
[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.
解决方案 »
- sql求同列前两条记录之差
- 求助: mysql中innodb引擎对于查询缓存的影响
- bin/mysqld_safe: Permission denied 这个问题如何解决啊?
- mysql病态问题,求高手解决
- 晕···
- 关于mysql proxy的问题
- winmysqladmin中的mysql.ini中的user和password是干什么用的?
- 请问各位的mysql用的JDBC是哪下的,怎么才能正确加载啊,为什么我在mysql网站下的JDBC不好用啊,是不是加载错了??
- mysql 查询子节点数量
- 数据库表设计问题
- mysql的查询问题,有关select .... where ..in ()的
- mysql中大家用什么类型代替boolean类型。
up
我在配置myodbc时在servername选项中填了点(.)在my.ini中添加了enable-named-pipe
然后重启动了服务,就再也没有出现连不上的现象。
谢谢!