[ic] Upgraded to mysql 4.1.20 and now errors ?

[Kevin Walsh]

Jim Toro <jimtoro at liwebtech.com> wrote:
> We have been running IC 5.4.0 and Mysql 4.0.2x for a long time and today
> we had to upgrade to mysql 4.1.20, we did the compile and install along
> with the latest DBI and DBD, everything seems to come up ok but when 
> starting interchange we get these errrors:
>
> [snip: access denied errors]
>
> Interchange does come up but of course we cannot do anything with the
> database at this point.
> 
> I put the "old-passwords" setting in the my.cnf in the [mysqld] section 
> too. Did full reboots, etc..
> 
> What am I missing ???? Does something else have to be done to the database
> when going from mysql 4.0 to 4.1 or is it a IC or Perl issue ?
> 
You probably didn't run the "mysql_fix_privilege_tables", as instructed
to in the MySQL 4.0 -> 4.1 upgrade guide.  Backup your database and
run it now.  That should fix it.

The servers I have that run MySQL were all upgraded to 4.1.20 a long
time ago.  4.1.20 is now the default version supplied with Gentoo
GNU/Linux.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/