Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Paul DuBois
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 me

Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread SGreen
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/mysq

RE: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Kevin Cowley
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 R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alche