Need your help about security

[michael bao]

Hi there,

I have some questions about Mysql Security. Last weekend, all tables in one database of Mysql were dropped. It is second times since we upgraded our server to windows server 2003.

When I check the log file, it show me info as following,

040805 8:20:00 mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
MySql: ready for connections.
Version: '4.1.0-alpha-max-nt' socket: '' port: 3306
040905 20:34:47 read_first_with_key: Got error 126 when reading table

After that, I copy all backup table files to the database directory. Everything was fine.

My question is,

(1)Could you tell me what reason made it happen? Hacker, wrong operation, wrong code or anything else.
(2)Could you tell me how to make the Mysql safe step by step? More details, better.
(3)How to record more info about unnormal shutdown of Mysql?

Thanks for your help, looking forward to hearing from you,

Michael Email:[e-mail]