Question

is it safe to delete/alter some table in information_schema? or is there anyway to alter them or safe to delete them all

Posted June 2, 2018 1k views
MySQLMariaDB

i am trying to to install a component and it says that a particular table of that component exists in mysql..i am done with (drop if table exists; flush tables; and create tables; both in phpmyadmin and ubuntu terminal command)

  • tables - name of the component’s table that exist

but failed to do so…when im trying to search where the component table exists it points to information_schema (which is hard to edit because the table is like an imaginary table) no command can be done.

anyone knows how to delete/edit/alter an existing table in information_schema (??)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi @mjbt,

INFORMATIONSCHEMA, PERFORMANCESCHEMA and mysql (and possibly more) are special system tables in MySQL. Please refer to the MySQL documentation on this - Documentation

In other words, no, don’t attempt to delete/alter them. You need them in order to have a functional MySQL installation. Moreover, they’re probably protected from any regular way of deleting/altering them.

If you are experiencing issues with the installation, I’ll recommend going to developer and see if the error can be fixed by them.

Regards,
KDSys

Submit an Answer