PHPmyAdmin 默认数据库 [英] PHPmyAdmin Default Databases

问题描述

好的，这更像是一个让我的房子井井有条"的问题.

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

PHPmyAdmin 已安装，但它默认安装了一堆数据库.

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)•测试•webauth (1)

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

我最近删除了其中的一堆，但之后我在访问 PHPmyAdmin 时遇到了很多问题，不得不重新安装.总而言之，我可以愉快地删除这些而不影响我的系统吗?

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?

推荐答案

并非所有列出的数据库都与 phpMyAdmin 相关.一些是 MySQL 正常运行所必需的.

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 大概是用于XAMPP自带的cd集合示例数据库.webauth 可能也是 XAMPP 的一部分.

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

唯一与 phpMyAdmin 相关的数据库(您可能已经猜到了)是 phpmyadmin，您可以删除它，但让它存在会提高性能，并添加更多功能到 phpMyAdmin.

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.

这篇关于PHPmyAdmin 默认数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！