MySQL 4.1+ Password Incompatibility

------_=_NextPart_001_01C5A97A.3803DA4F
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm having trouble getting DBI connect to a MySQL 4.1+ server. I have
to use MySQL's OLD_PASSWORD to set the password on the server in order
for DBI to connect. This means less secure passwords for MySQL -- 41
byte hashes instead of 45 byte hashes. Could someone assist in helping
me connect to MySQL through DBI using the newer password scheme?
=20
Thanks in advance,
Shawn Iwinski

------_=_NextPart_001_01C5A97A.3803DA4F--

Re: MySQL 4.1+ Password Incompatibility

Shawn Iwinski (siwinski) wrote:

> I'm having trouble getting DBI connect to a MySQL 4.1+ server. I have
> to use MySQL's OLD_PASSWORD to set the password on the server in order

This isn't a DBI issue, the problem is that the passwords in your
privilage tables (IE from 3.x or 4.0) are not compatible with MySQL
4.1's authentication protocol.

You're only two options are:
1) just use old_passwords (IE it has to be in ~/.my.cnf for CLI use =
MySQL issue not Perl)
2) update your privileges to 4.1 auth schema
3) go back to 4.0 or whatever

You may find other options from the mysql folks :)

HTH :) Lee.M - JupiterHost.Net

Re: MySQL 4.1+ Password Incompatibility

You'll need to rebuild DBD::mysql linked against a 4.1 MySQL client library.


On 8/25/05 8:38, "Shawn Iwinski (siwinski)" wrote:

> I'm having trouble getting DBI connect to a MySQL 4.1+ server. I have
> to use MySQL's OLD_PASSWORD to set the password on the server in order
> for DBI to connect. This means less secure passwords for MySQL -- 41
> byte hashes instead of 45 byte hashes. Could someone assist in helping
> me connect to MySQL through DBI using the newer password scheme?
>
> Thanks in advance,
> Shawn Iwinski

Re: MySQL 4.1+ Password Incompatibility

Paul DuBois said:
> You'll need to rebuild DBD::mysql linked against a 4.1 MySQL client
> library.
>
>
> On 8/25/05 8:38, "Shawn Iwinski (siwinski)" wrote:
>
>> I'm having trouble getting DBI connect to a MySQL 4.1+ server. I have
>> to use MySQL's OLD_PASSWORD to set the password on the server in order
>> for DBI to connect. This means less secure passwords for MySQL -- 41
>> byte hashes instead of 45 byte hashes. Could someone assist in
>> helping me connect to MySQL through DBI using the newer password
>> scheme?
>>
>> Thanks in advance,
>> Shawn Iwinski
Does anyone know of activestate's DBD::mysql has been rebuilt yet? Bumped
my forhead against that problem awhile back. Thanks

-------

William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061

Re: MySQL 4.1+ Password Incompatibility

On Thu, 25 Aug 2005 09:00:37 -0700 (PDT), William R. Mussatto wrote:

Hi William

> Does anyone know of activestate's DBD::mysql has been rebuilt yet?
> Bumped my forhead against that problem awhile back. Thanks

You could try here
http://cpan.uwinnipeg.ca/search?query=3DDBD%3A%3Amysql&mode= 3Dmodule

--
Cheers
Ron Savage, ron@savage.net.au on 26/08/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company