IIS 6.0 and Mysql Connection Issue

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
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

IIS 6.0 and Mysql Connection Issue

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

MySQLi is available for PHP 4 last I used it. :?
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post 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)
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

That did it Feyd! Went to PHP 5.x installed the proper extensions and I'm in buisness! Thanks sir!!!!

8)
Post Reply