I was just reading about this on the MySQL web site.
It seems they have change the authentication protocol
starting with version 4.1
There is a note that clients like PHP, Perl etc will
need to be recompiled to support the NEW protocol. For
now I'm sticking with MySQL 4.0.1
Paul
--- "Michael G. Tracey" <[EMAIL PROTECTED]> wrote:
>
> Code below comes straight out of the manual. I can
> connect using mysql client on other pc, and using
> SQLyog. but Php will not connect. I can run php
> scripts with no problem otherwise.
>
> Setup is: Win2k - sp3; php 4.3.2 ; Mysql 4.1; Apache
> 2.
>
> This is the error I get:
>
>
> ;
> Warning: mysql_connect(): Client does not support
> authentication protocol requested by server.
> Consider upgrading MySQL client in
> C:\sokkit\site\mysql-conn.php on line 12
> Could not connect
>
> ****************************
>
>
> ;<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
> <html>
> <head>
> <title>Title here!</title>
> </head>
> <body>
>
>
>
> <?php
> /* Connecting, selecting database */
> $link = mysql_connect("localhost", "michael",
> "access")
> or die("Could not connect");
> print "Connected successfully";
> mysql_select_db("my_database") or die("Could not
> select database");
>
> /* Performing SQL query */
> $query = "SELECT * FROM my_table";
> $result = mysql_query($query) or die("Query
> failed");
>
> /* Printing results in HTML */
> print "<table>\n";
> while ($line = mysql_fetch_array($result,
> MYSQL_ASSOC)) {
> print "\t<tr>\n";
> foreach ($line as $col_value) {
> print "\t\t<td>$col_value</td>\n";
> }
> print "\t</tr>\n";
> }
> print "</table>\n";
>
> /* Free resultset */
> mysql_free_result($result);
>
> /* Closing connection */
> mysql_close($link);
> ?>
>
>
>
>
>
> </body>
> </html>
>
>
> Michael G. Tracey
>
> _______________________________________________
> Join Excite! - http://www.excite.com
> The most personalized portal on the Web!
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
