change collation on all existing databases, tables and columns

[Florian Effenberger]

Hello there,

I run MySQL 4.1.12 and have some databases with the default collation of
latin1_swedish_ci. I have edited the my.cnf file to read

default-collation = latin1_german1_ci

Now I would like to change the collation on all existing databases,
tables and columns to have the latin1_german1_ci collation, as the
my.cnf entry only works for new entries. Is there an easy command or
tool to achieve that? I don't want to send the appropriate command
mentioning every single database, table and column, but rather look for
a FOR loop or a wildcard.

Thanks
Florian