Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I just installed the LAMP server and PHPMyAdmin. Once I logged in I noticed databases already created and within them tons of tables and rows.

My question of course is whether I can just delete them all without failing the system in any way. Below you see what I saw once I entered the first database.

One of four database preinstalled.

share|improve this question
    
in what way is this related to ubuntu? –  don.joey Dec 28 '12 at 14:59
    
No, Don't delete it –  Tachyons Dec 28 '12 at 15:05
    
In future, you should really ask this type of question in serverfault.com. You'll get much better answers there. –  Flimm Dec 28 '12 at 15:20
add comment

1 Answer

up vote 4 down vote accepted

INFORMATION_SCHEMA, PERFORMANCE_SCHEMA and mysql (and possibly more) are special system tables in MySQL. Please refer to the MySQL documentation on this. One excerpt:

Usage Notes for the INFORMATION_SCHEMA Database

INFORMATION_SCHEMA is a database within each MySQL instance, the place that stores information about all the other databases that the MySQL server maintains. The INFORMATION_SCHEMA database contains several read-only tables. They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on them. Also, there is no database directory with that name.

So, no, don't attempt to delete 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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.