Bug #16012 the system database can be delete easily

• Submitted: 27 Dec 2005 11:12
• Modified: 30 Dec 2005 11:24
• Reporter: ming lu
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: *
• OS: Linux (linux)
• CPU Architecture: Any

[27 Dec 2005 11:12] ming lu

Description:
The system database can be delete easily (drop database mysql).  When it occurs, the mysql database system  breakdown. I think this is a latent problem.

How to repeat:
execute the following SQL statement:
  drop database mysql;

the mysql database breakdown 

Suggested fix:
The system database like 'mysql', 'information_schema' should be protected strictly. It will be helpfull to promote the robust of the database system.

[30 Dec 2005 11:24] Sergei Golubchik

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

If you don't want some user to drop mysql database you should not give him grants to do that.
Just like on linux you don't give write privileges on / to everybody.