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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

[Florian Effenberger]

;-)


- Original Message - 
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "Florian Effenberger" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 5:39 PM
Subject: Re: disabling version number


You can patch mysql source and recompile ;)

However, if someone has enough access rights on your system to run
"select version();", showing mysql version number should be the least
important of your problems.

Regards,
Joseph Bueno


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

[Florian Effenberger]

> No, why?

Part of my security concept, I generally disable all version numbers.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

disabling version number

[Florian Effenberger]

Hi,

is there any configuration directive of disabling the output of the MySQL
servers version number?

Thanks
Florian


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]