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

• 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屋！