So, this is totally one of those things that could've been solved by spending the five minutes necessary to RTFM.
For future reference, it would've also been helpful to provide us with some context about your issue. Great, you installed MySQL 5.0, but you neglected to tell us that you're using a database generated by a MySQL version that predates MySQL 4.1. The important point here is that you're UPGRADING MySQL. In the future, you'll want to spend some time reading the Upgrade portion of the MySQL Manual, paying close attention to the list of things that could potentially cause you large headaches. In general -- and especially with databases -- you want to do this BEFORE you upgrade. You would also be wise to back up, too. Here's the issue that's causing you problems: Earlier versions of MySQL use a different authentication scheme than MySQL 4.1+. Your database and your MySQL Client should both support the current authentication scheme, too. They really couldn't have been more in-your-face about this in the manual: http://dev.mysql.com/doc/refman/5.0/en/old-client.html http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html http://dev.mysql.com/doc/refman/5.0/en/php-problems.html You probably also want to take the time to review the MySQL portion of the PHP manual. http://us2.php.net/manual/en/ref.mysql.php You'll see that PHP4 has the MySQL client library pre-compiled in the Windows distribution. (Just one of the zillion reasons to just bite the bullet and build yourself a *nix development box or use VMWare and run a *nix environment on your Windows box) PHP5 does not include the MySQL client libraries, and as such, you would be less likely to run into any issues stemming from an outdated MySQL client library; however, you'll get all of the issues involved in porting PHP4 to PHP5. -Jeromie > > > > >Now that ive installed MySQL 5.0.16 im getting errors of the following > > Warning: mysql_connect(): Client does not support authentication >protocol requested by server; consider upgrading MySQL client in >D:\SourceCode\Connect.php on line 2 > >Could not connect: Client does not support authentication protocol requested >by server; consider upgrading MySQL client > > > > This ver of MySQL is a pain in the ass ,,, how can I fix this problem ?? > > Please help > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
