Re: Removing schema information from MySQL system files

[Bill Karwin]

These files store the privileges to your database objects. There shouldn't be any proprietary data stored there, just the names of the database, tables and columns.

But if you want to erase all mention of them, I think you can try this sequence. I have not tested this to verify that it eliminates all occurrances of the strings, you can test that.

DELETE FROM db WHERE db = 'mydatabasename';
DELETE FROM host WHERE db = 'mydatabasename';
DELETE FROM tables_priv WHERE db = 'mydatabasename';
DELETE FROM columns_priv WHERE db = 'mydatabasename';

And if you use MySQL 5.0 or later:
DELETE FROM proc WHERE db = 'mydatabasename';
DELETE FROM procs_priv WHERE db = 'mydatabasename';

Then after these statements are done, do this:
FLUSH PRIVILEGES;

Regards,
Bill K.