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 (??)
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi @mjbt,
INFORMATION_SCHEMA, PERFORMANCE_SCHEMA 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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.