Can't connect to DB after upgrading to mysql 4.1.5
Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin, $dbpasswd) or die Cannot connect to $dbname: . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI-connect(dbname;host=host) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client What shall I do? Please help. Thanks. Claire __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't connect to DB after upgrading to mysql 4.1.5
Claire The Authentication protocols changed with 4.1. If you do a search on the archive this subject has come up several times. Either upgrade your perl interface or make 4.1.5 use the old protocol. Kevin Cowley RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Claire Lee [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 16:28 To: [EMAIL PROTECTED] Subject: Can't connect to DB after upgrading to mysql 4.1.5 Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin, $dbpasswd) or die Cannot connect to $dbname: . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI-connect(dbname;host=host) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client What shall I do? Please help. Thanks. Claire __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to DB after upgrading to mysql 4.1.5
If you are using an ODBC driver or some other pre-4.1 library to connect to a post-4.1 MySQL server you can get the message you describe. Here is some reading about cross-version authentication issues: http://dev.mysql.com/doc/mysql/en/Problems.html (esp section A.2) http://dev.mysql.com/doc/mysql/en/Access_denied.html http://dev.mysql.com/doc/mysql/en/Application_password_use.html http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down to is that your pre-4.1 client is trying to validate a much longer password hash from the server against a locally created hash built from the password you are using to login with. Solve this by doing any one of these three things: 1) force your post-4.1 server to always use the old-style hashes (less secure) 2) update certain records in the mysql.user table using the OLD_PASSWORD() function (preferred) 3) upgrade your client (not always possible) The reading describes how to do all of those suggestions. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Claire Lee [EMAIL PROTECTED] wrote on 10/05/2004 11:27:43 AM: Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin, $dbpasswd) or die Cannot connect to $dbname: . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI-connect(dbname;host=host) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client What shall I do? Please help. Thanks. Claire __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to DB after upgrading to mysql 4.1.5
At 8:27 -0700 10/5/04, Claire Lee wrote: Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin, $dbpasswd) or die Cannot connect to $dbname: . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI-connect(dbname;host=host) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client Recompile DBD::mysql so that it links in the 4.1.5 client library. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]