[FIXED] PHPmyAdmin Default Databases

Issue

Ok this is more of a 'Keeping my house in order' question.

PHPmyAdmin is installed but it has a bunch of databases installed as default.

•cdcol (1) •information_schema (37) •mysql (24) •performance_schema (17) •phpmyadmin (8) •test •webauth (1)

I recently deleted a bunch of these but after that I had lots of issues accessing PHPmyAdmin and had to re-install. Anyway long story short can I happily delete these without effecting my system?

Solution

Not all of those listed databases are phpMyAdmin related. Some are required for MySQL to operate normally.

• performance_schema http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
• information_schema http://dev.mysql.com/doc/refman/5.5/en/information-schema.html
• test http://dev.mysql.com/doc/refman/5.0/en/database-use.html
• mysql http://dev.mysql.com/doc/refman/5.5/en//adding-users.html

cdcol Probably is for the cd collection sample database that comes with XAMPP. webauth is probably part of XAMPP as well.

The only phpMyAdmin related database (as you probably already guessed) is phpmyadmin, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin.

Answered By - racetrack