PHPmyAdmin Default Databases

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)$';

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.

Tags:

Phpmyadmin