phpmyadmin启用drop database语句 [英] phpmyadmin enable drop database statement

问题描述

我的寄存供应商通知我超过了我的1000表限制。我有很多数据库，并希望一次删除更多。

I was alerted by my hosting provider that I exceed my 1000 table limit. I have a lot of databases and would like to delete more at once. Unfortunaltley they don't have a multiselect feature so I decided to use a query in phpmyadmin.

当我尝试类似 DROP数据库some_name

When I try something like DROP database some_name I get DROP DATABASE statements are disables

有人知道是否可以启用它们一种不同的方式删除多个数据库？

Does anyone know if it's possible to enable them or a different way to delete multiple databases?

推荐答案

看起来像有一个 phpMyAdmin设置您需要在config.inc.php中编辑。

It looks like there is a phpMyAdmin setting that you need to edit in config.inc.php.

布林$ cfg ['AllowUserDropDatabase']（第503行）

向普通用户显示删除数据库

show a 'Drop database' link to normal users

这篇关于phpmyadmin启用drop database语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！