blocks|key|155304|text|您可以在Cpanel中删除数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155305|在Cpanel中，转到数据库，在那里你会看到所有创建的数据库，你可以删除这个数据库。|155306|http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete数据库|offset|length|155307|或者，在实时服务器上，如果用户具有特权，则可以在phpmyadmin的sql选项卡中运行命令。|155308|drop+database+databasename;|code-block|syntax|javascript|155309|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete^0|0|0|0|2F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$F|Z|G|10|1|11]]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

You can delete the database in Cpanel.

In Cpanel go to databases and there you will see all created databases and you can delete this database.

<a href="http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete" rel="noreferrer">http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete</a> a Database

or other wise on live server if user have privileges you can run command in sql tab of phpmyadmin. 

<pre><code>drop database databasename;
</code></pre>

blocks|key|4661595|text|成功登录cPanel后，在phpMyAdmin图标附近有另一个图标MySQL+Databases；单击该图标。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4661596|​|4661597|📷|atomic|4661598|4661599|这将把您带到数据库列表页面。|4661600|在操作列中，您可以找到delete+database选项，单击该选项可删除您的数据库！|4661601|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/43f22f2cfb27a7ff901fd50b838dced6.png|imageAlt^0|D|A|X|F|0|0|0|1|0|0|0|0|B|F|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|K|3|G|5|6|7|18|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|19|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|P|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W|X|-4]]]]

After successful login to cPanel, near to the <code>phpMyAdmin</code> icon there is another icon <code>MySQL Databases</code>; click on that.

<img src="https://i.stack.imgur.com/mqYOT.png" alt="enter image description here">

That brings you to the database listing page.

In the action column you can find the <code>delete database</code> option click on that to delete your database!

blocks|key|4661636|text|选择左侧的数据库。然后在右中上方，你可以找到Operations。在go中，表示删除数据库(DROP)。就这样。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4661637|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

select database on the left side. Then on the right-central top you can find Operations. In that go for remove database (DROP). That's all.

blocks|key|155433|text|从上面michael的answer中获取一个队列，我在localhost中的phpMyAdmin控制台上找不到DROP+Database命令。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|155434|很明显，我错过了一个场景。转到phpMyAdmin文件夹的config.inc.php文件，并添加以下内容：|155435|$cfg['AllowUserDropDatabase']+=+true;|155436|保存并重新启动本地服务器，该命令将出现在控制台中。|155437|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/24035555/2491276^0|R|9|12|A|B|6|0|0|F|A|T|E|0|0|11|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|19|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S]]]]

Taking a queue from michael's <a href="https://stackoverflow.com/a/24035555/2491276">answer</a> above, I was unable to find the DROP Database command on my <code>phpMyAdmin</code> console in the <code>localhost</code>.

Apparantly I was missing a setting. Go to <code>config.inc.php</code> file of the <code>phpMyAdmin</code> folder, and add this:

<code>$cfg['AllowUserDropDatabase'] = true;</code>

Save and restart the local server and the command appears inside the console.

blocks|key|155470|text|database_name+->+Operations+->+Remove+->+->点击删除数据库(+drop+)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155471|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

database_name -> Operations -> Remove database -> click on drop the database (DROP)

blocks|key|4661786|text|操作中的删除/删除选项在我的版本中不存在。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4661787|转到CPanel+->+MySQLDatabase+(PhPMyAdmin旁边的图标)+->+check+the+DB+to+be+delete+->+delete。|4661788|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The delete / drop option in operations is not present in my version. 

Go to CPanel -> MySQLDatabase (icon next to PhPMyAdmin) -> check the DB to be delete -> delete.

blocks|key|155546|text|你可以关注上传的图片|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155547|​|155548|📷|atomic|offset|length|155549|155550|然后选择要删除的数据库|155551|155552|155553|155554|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/100a1c2d8771f97b9322b671c711212a.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/791a78bf9b86d173d460be35e68fb44b.png^0|0|0|0|1|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|11|8|@]|9|@$G|12|H|13|1|14]]|A|$]]|$1|I|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|M|3|E|5|F|7|18|8|@]|9|@$G|19|H|1A|1|1B]]|A|$]]|$1|N|3|C|5|6|7|1C|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V|W|-4]]|X|$5|R|S|T|A|$U|Y|W|-4]]]]

You can follow uploaded images

<img src="https://i.stack.imgur.com/ysJoc.png" alt="enter image description here">

Then select which database you want to delete

<img src="https://i.stack.imgur.com/iCjsz.png" alt="enter image description here">

blocks|key|4661879|text|进入所选数据库的操作页签，单击[删除数据库(DROP)]，即可将其删除。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4661880|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Go to operations tab for the selected database and click "Drop the database (DROP)" to delete it.

blocks|key|155640|text|如果要从phpmyAdmin或mySQl中删除数据库。只需转到SQL命令并写入命令"drop+DATABASE+databasename;“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|155641|示例：drop+DATABASE+rainbowonlineshopping;|offset|length|style|CODE|155642|​|155643|📷|atomic|155644|155645|然后点击"Go“按钮。您的数据库将被删除，您将获得如下信息|155646|155647|155648|155649|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b4f2987e3a53625937661db80ec2b692.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/f175db9d48845a0a86ff7e7a3e1bbc23.png^0|0|3|10|0|0|0|1|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@$D|19|E|1A|1|1B]]|A|$]]|$1|M|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|I|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|K|5|L|7|1F|8|@]|9|@$D|1G|E|1H|1|1I]]|A|$]]|$1|R|3|I|5|6|7|1J|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]|11|$5|V|W|X|A|$Y|12|10|-4]]]]

If you want to delete your database from phpmyAdmin or mySQl. Simply go to SQL command and write command "drop DATABASE databasename;"

Example: <code>drop DATABASE rainbowonlineshopping;</code>

<a href="https://i.stack.imgur.com/9IG0V.png" rel="noreferrer"><img src="https://i.stack.imgur.com/9IG0V.png" alt="enter image description here"></a>

Then click on "Go" Button. Your Database will be deleted and you get information like this

<a href="https://i.stack.imgur.com/pYdaE.png" rel="noreferrer"><img src="https://i.stack.imgur.com/pYdaE.png" alt="enter image description here"></a>

By mistake, I have created a duplicate database in the phpMyAdmin page of cPanel. I want to delete this database, but I am not able to find any delete button in the UI.

How to delete a database in phpMyAdmin?

Delete a database in phpMyAdmin

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

错误地，我在cPanel的phpMyAdmin页面中创建了一个重复的数据库。我想删除此数据库，但在UI中找不到任何删除按钮。如何在phpMyAdmin中删除数据库？

问在phpMyAdmin中删除数据库
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在phpMyAdmin中删除数据库EN