PHPmyAdmin Default Databases

Question

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?

Answer 1

Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.

$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';

Answer 2

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.