Re: [PHP-DB] Consider upgrading MySQL client .... how do I do this?
Sorry about coming into this thread late. You should read this page: http://www.mysql.com/doc/en/Password_hashing.html It details how to upgrade your user tables to MySQL 4.1.x and still allow old clients to connect to the server. On Wed, 03 Sep 2003 19:50:37 +1000, Vinoaj Vijeyakumaar spoke thusly about [PHP-DB] Consider upgrading MySQL client how do I do this?: Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select feature rather than attempt learning JOINs. It is now 7 hours later, and I keep getting the following error when trying to connect to my database: Warning: mysql_connect(): Client does not support authentication protocol requested by server. Consider upgrading MySQL client Running phpinfo() shows Client API version 3.23.49 under mySQL. Searching around the net all day, the closest explanation I could find was that PHP does not have a client API to interface with MySQL 4.1.x. The solution suggested was to use an ODBC driver to interface between PHP and MySQL but indicated that this may be slower. My question, therefore, is - is there a way to upgrade the MySQL client in PHP 4.3.3? If not, what are the alternatives (apart from reverting back to MySQL 4.0.x of course). Thanks in advance. Vinny. --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Consider upgrading MySQL client .... how do I do this?
one way it to use old_password ()instead of password(), when creating new user name, or update the password for those existing user names with the old_password() function. but then this will force you to use the old password() function, which doesn't really help much... Vinoaj Vijeyakumaar wrote: Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select feature rather than attempt learning JOINs. It is now 7 hours later, and I keep getting the following error when trying to connect to my database: Warning: mysql_connect(): Client does not support authentication protocol requested by server. Consider upgrading MySQL client Running phpinfo() shows Client API version 3.23.49 under mySQL. Searching around the net all day, the closest explanation I could find was that PHP does not have a client API to interface with MySQL 4.1.x. The solution suggested was to use an ODBC driver to interface between PHP and MySQL but indicated that this may be slower. My question, therefore, is - is there a way to upgrade the MySQL client in PHP 4.3.3? If not, what are the alternatives (apart from reverting back to MySQL 4.0.x of course). Thanks in advance. Vinny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Consider upgrading MySQL client .... how do I do this?
On 03 September 2003 10:51, Vinoaj Vijeyakumaar contributed these pearls of wisdom: Hi, Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select feature rather than attempt learning JOINs. It is now 7 hours later, and I keep getting the following error when trying to connect to my database: Warning: mysql_connect(): Client does not support authentication protocol requested by server. Consider upgrading MySQL client My question, therefore, is - is there a way to upgrade the MySQL client in PHP 4.3.3? If not, what are the alternatives (apart from reverting back to MySQL 4.0.x of course). I don't believe so, although I'm not absolutely certain as I don't use MySQL myself. My understanding, however, is that support for MySQL 4.1 will not be available until PHP 5.0. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
