just google for it and you will get lots of hits. Newer versions of 
Mysql need different client authentication.

I would try to use
$db_type = "mysqli" instead of the older "MYSQL" interface and see if it 
solves the problem.

from PEAR DB docs 
(http://pear.php.net/manual/en/package.database.db.intro-dsn.php)
mysqli -> MySQL (for MySQL >= 4.1) (requires PHP 5) (since DB 1.6.3)

Or use any of the suggested solutions from google, like this one
   http://dev.mysql.com/doc/refman/5.0/en/old-client.html

armin

Chris Beaart wrote:
> Wow, that's a quick answer.
> I tried your hints. Running the exact created SQL-string in the DB-console
> works perfectly.
> When I enter the more verbose logging code I get the following message:
> [nativecode=Client does not support authentication protocol requested by
> server; consider upgrading MySQL client] **
> mysql://root:[EMAIL PROTECTED]/dop
> 
> Do you have any further suggestions?
> Thanks,
> Chris.
> 
> 
> -----Oorspronkelijk bericht-----
> Van: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Namens Armin Burger
> Verzonden: zondag 3 december 2006 16:37
> Aan: Chris Beaart
> CC: [email protected]
> Onderwerp: Re: [pmapper-users] Nothing happens while trying to connect to
> MYSQL database
> 
> use some more verbose logging after connection and query, like
> 
> if (DB::isError($dbh)) {
>     error_log($dbh->getDebugInfo());
> }
> 
> 
> if (DB::isError($result)) {
>     error_log($result->getDebugInfo());
> }
> 
> 
> And try what happens when you want to run the created SQL string from a 
> DB console.
> 
> Armin
> 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to