phpmyadmin 启用删除数据库语句

2022-01-05 00:00:00 database mysql phpmyadmin

我的托管服务提供商提醒我超过了 1000 张桌子的限制.我有很多数据库,想一次删除更多.不幸的是,他们没有多选功能,所以我决定在 phpmyadmin 中使用查询.

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 database some_name 这样的东西时,我得到 DROP DATABASE 语句被禁用

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?

推荐答案

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

布尔值 $cfg['AllowUserDropDatabase'](第 503 行)

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

show a 'Drop database' link to normal users

相关文章