"Siegfried Heintze" <siegfried@stripped> wrote on 06/30/2005 10:29:48
PM:
> Approximately a half year ago I started to install bugzilla on windows
which
> uses mysql and perl.
>
> After much grief, I discovered that there was a problem with windows
perl
> and the latest version of mysql at the time. I finally solved the
problem by
> rolling back to 4.0.23.
>
> It looks like there are some nice features in 4.1 but they won't work
for
> me, unless someone has fixed the perl DBI interface.
>
> Has anyone tried the newer versions with perl DBI on windows? How does
v5
> work, for example?
>
> I'm reluctant to try it out myself because I have applications using
mysql
> and I would not want to break them by installing v5.
>
> Thanks,
> Siegfried
>
The problem with using the older PERL library with a MySQL server 4.1+
isn't in the communications interface, it's with the authentication. You
can still use older clients (using the smaller and weaker password hashes)
with the newer MySQL databases just fine. You have 3 options to make them
compatible:
A) Upgrade your PERL library (which you said you cannot do yet)
B) Tell the server to ALWAYS use the older password hashes. You do this
with the --old-password option
C) Manually recreate the password hash for the older client's `user`
account by UPDATE-ing the `mysql`.`user` table using the OLD_PASSWORD()
function. Don't forget to FLUSH PRIVILEGES after any manual manipulation
of the tables in the `mysql` database so that your changes will be
recognized by the server.
These methods are described in more detail here:
http://dev.mysql.com/doc/mysql/en/old-client.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
