Page 1 of 1

IIS 6.0 and Mysql Connection Issue

Posted: Tue Mar 28, 2006 12:58 pm
by neophyte
I'm having trouble connecting to Mysql on IIS 6 across a lan on Win Server 2003. No problem logging in as root at the command prompt. PhpMyAdmin says:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

MySQL said: Documentation
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
My own connection script produces:


Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\index.php on line 1
I'm running Mysql 4.1.

I don't know if 3306 is blocked or not.

Can anyone tell me if there is something else besides 3306 block that might be causing this problem or is there a fix to this problem?

Posted: Tue Mar 28, 2006 1:03 pm
by feyd
that's usually an incompatibility between the client API you're using and the one MySQL wants. What version of MySQL are you using and what API are you using in PHP? I'll guess you're running 4.1+ for MySQL and 3.23+ for PHP. That'd be the problem. Try switching to MySQLi

Posted: Tue Mar 28, 2006 1:26 pm
by neophyte
Ahhhhh but here's the problem:

I either have to fall back to an older version of Mysql or upgrade to PHP 5?

There is no php4 support for mysqli as far as I read at php.net.

The client will be using it to run Drupal and few other apps for the company intranet.

So the question is... fall back or upgrade to PHP 5?

Posted: Tue Mar 28, 2006 1:31 pm
by feyd
MySQLi is available for PHP 4 last I used it. :?

Posted: Tue Mar 28, 2006 2:00 pm
by neophyte
According to the manual..

php_mysqli.dll MySQLi functions PHP >= 5.0.0, requires libmysql.dll (libmysqli.dll in PHP <= 5.0.2) (bundled)

Posted: Tue Mar 28, 2006 2:16 pm
by neophyte
That did it Feyd! Went to PHP 5.x installed the proper extensions and I'm in buisness! Thanks sir!!!!

8)