mysql set up problem

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
dila125
Forum Newbie
Posts: 7
Joined: Fri Apr 09, 2004 7:11 am

mysql set up problem

Post by dila125 »

PHP 4.3.4
MySQL 3.23
Windows 2003/IIS6

I have a PHP script for connecting to a mysql database. When procesing the
script through the command line, everything works fine, but through an
internet browser the following error is displayed:

Warning: mysql_pconnect(): Can't create TCP/IP socket (10041)

More info about the error:
WSAEPROTOTYPE (10041)
Protocol wrong type for socket.
A protocol was specified in the socket function call that does not
support the semantics of the socket type requested. For example, the
ARPA Internet UDP protocol cannot be specified with a socket type of
SOCK_STREAM.

Other aspects of PHP work ok, and an indentical PHP/MySQL setup works fine
on my Windows 2000/IIS5 machine. Both machines have PHP/MySQL setup
according to the following instructions:
http://s92192454.onlinehome.us./PHP_on_ ... r_IIS.html

Any help is really appreciated.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

wrong forum. moved
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

I had this trouble with MySQL running on Win2K3 Server. I doubt if you can get winmysqladmin.exe(bin directory) to work since your tcp/ip is not ok. Somehow (???) Win2k3 Server does not seem to configure tcp/ip unless you actually are connected to a lan or internet. So if you are running Win2k3 server on a single machine then just try setting a network connection adn then run the scripts (mysql actually) again.
Otherwise you can connect using named pipes in 2k & 2k3. I don't know how this works but its given in http://dev.mysql.com/doc/mysql/en/Windo ... erver.html
Post Reply