Can't create TCP/IP socket (10106)

r00s2er

My Setup:
Windows XP (have all the service packs installed)
PHP 4.3.1
MYSQL 3.23.55
OrionSever 1.5.2b

When PHP attempts to access MYSQL, I get the following error:
Warning mysql_connect() [function mysql-connect]: Can't create TCP/IP socket (10106) in ......

Does anyone know how to resolve this issue?

Thanks... Sam.

Norman

Originally posted by r00s2er
My Setup:
Windows XP (have all the service packs installed)
PHP 4.3.1
MYSQL 3.23.55
OrionSever 1.5.2b

When PHP attempts to access MYSQL, I get the following error:
Warning mysql_connect() [function mysql-connect]: Can't create TCP/IP socket (10106) in ......

Does anyone know how to resolve this issue?

Thanks... Sam.

What does your connection string look like:

ie: mysql_connect("localhost", "username", "password");

I've noticed I get this error alot when I try to connect to the FQDN , but when I use localhost, it worked fine.. 🙂

r00s2er

my connection string looks like...

$dbh = mysql_connect("localhost", "username", "password") or die( sql_error() );

I think i have tried using the domain name also, but received the same error.

Is it right to assume my problem exists in one of the settings in the PHP.ini or MY.ini files?

THanks.

ZibingsCoder

I've had a similar issue to this one. I'm setting up PHP 5.1.6 on IIS 6.0 running on a Windows 2003 R2 Server with an x64 bit architecture. Have had to do quite a bit of fiddling to get IIS working with PHP, but all is going well now save for this issue. When trying to connect to MySQL using any library, you receive this 'Can't create TCP/IP socket' error. I've looked around, and tried everything from setting the server's SYSTEMDIR folder in PATH settings to turning on 'enable named-binding' in the my.ini file. Root can access anything from anywhere, but individual users are unable to access the database on the server.

Anyone know of any solutions to this?

MarkR

Try disabling all third party "Personal firewall" products, then try again.

Mark

ZibingsCoder

I'm not sure about the other poster, but my server has no firewall services/programs running on it.

Andy