"Siegfried Heintze" <[EMAIL PROTECTED]> 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