Re: DB connection problem
| From: | John W. Holmes | Date: | Fri, 19 Mar 2004 14:07:28 +0000 |
| Subject: | Re: DB connection problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-180958@lists.php.net to get a copy of this message | ||
From: "Khalid Judeh" <khjudeh@yahoo.com>
> i have a problem connecting to mysql db, i use the following code to
connect to the db:
> $DBConn = mysql_connect("localhost", "myusername","mypassword")
> or
die("Could not connect to database, " . mysql_error());
> mysql_select_db("db1", $DBConn);
>
> and i get the following error:
> Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
c:\inetpub\wwwroot\php\db_test.php on line 33
> Could not connect to database, Client does not support authentication
protocol requested by server; consider upgrading MySQL client
Have you considered upgrading the MySQL client?
:)
It sounds like MySQL was upgraded on the server, but PHP was not recompiled
to support the version. For example, I do not think that MySQL clients v3
will work with MySQL 4.1 and above. Check with the MySQL site to be sure.
---John Holmes...