使用mysqladmin删除数据库
您需要特殊权限才能创建或删除MySQLi数据库.因此，假设您有权访问root用户，您可以使用mysql mysqladmin 二进制文件创建任何数据库.
删除任何数据库时要小心，因为您将失去所有数据库数据库中可用的数据.
以下是删除前一章中创建的数据库的示例 :
[root@host]# mysqladmin -u root -p drop TUTORIALSEnter password:******
这将给出你发出警告，它会确认你是否真的要删除这个数据库.
Dropping the database is potentially a very bad thing to do.Any data stored in the database will be destroyed.Do you really want to drop the 'TUTORIALS' database [y/N] yDatabase "TUTORIALS" dropped
使用PHP脚本删除数据库
PHP使用查询函数创建或删除MySQLi数据库.此函数接受两个参数，成功时返回TRUE，失败时返回FALSE.
示例
尝试以下示例删除数据库 :
Connecting MySQLi Server>/title> </head> <body> <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = '<Password Here>'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ){ echo 'Connected failure<br>'; } echo 'Connected successfully<br>'; $sql = "DROP DATABASE TUTORIALS"; if (mysqli_query($conn, $sql)) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . mysqli_error($conn); } mysqli_close($conn); ?> </body></html></pre><p></p><p><strong>警告</strong> : 使用PHP脚本删除数据库时，它不会提示您进行任何确认.因此在删除MySQLi数据库时要小心.</p><p>如果连接和删除数据库成功，那么示例输出应该是这样的 :</p><pre class="结果未翻译">Connected successfullyDatabase deleted successfully</pre> </article> </div> </div> </ggg> <aside class="d-none d-lg-block col-lg-2"> <section> <div class=""> <form action="/helpdoc/Search" target="_blank" autocomplete="off"> <div class="input-group"> <input type="text" name="kw" value="" class="form-control" placeholder="输入关键词搜索"> <button class="btn btn-outline-secondary" type="submit">搜索</button> </div> </form> </div> <div class="list-group-item-heading mt-2"> <h4>推荐阅读</h4> </div> <ul class="list-group mb-2 sticky-top"> <li class="list-group-item"> <a href="/detail/2022/1104/9CC34465FE9CD5CA" class="w-100 d-inline-block text-truncate" title="C++ switch case 语句" target="_blank"> C++ switch case 语句 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1104/18FCE01C6FC86BC3" class="w-100 d-inline-block text-truncate" title="ASP.NET Core 3.0安装配置使用NLog的方法及示例代码" target="_blank"> ASP.NET Core 3.0安装配置使用NLog的方法及示例代码 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1104/5CF2C006724B0545" class="w-100 d-inline-block text-truncate" title="JavaScript(JS) Math.acos( x )" target="_blank"> JavaScript(JS) Math.acos( x ) </a> </li> <li class="list-group-item"> <a href="/detail/2022/1107/32678276F815F6E8" class="w-100 d-inline-block text-truncate" title="Java.util.LinkedList类" target="_blank"> Java.util.LinkedList类 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/955011DE7A7DCD6C" class="w-100 d-inline-block text-truncate" title="JUnit - 参数化测试" target="_blank"> JUnit - 参数化测试 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/C9F73D6B47971B85" class="w-100 d-inline-block text-truncate" title="ETL测试 - 备份恢复" target="_blank"> ETL测试 - 备份恢复 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/1B718EA789726D19" class="w-100 d-inline-block text-truncate" title="Ethical Hacking - TCP / IP劫持" target="_blank"> Ethical Hacking - TCP / IP劫持 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/CC9B8530671B8C4B" class="w-100 d-inline-block text-truncate" title="Joomla - 私信" target="_blank"> Joomla - 私信 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/F1CC64EA5B76FDBC" class="w-100 d-inline-block text-truncate" title="Ext.js - 方法" target="_blank"> Ext.js - 方法 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/336F5074D5988841" class="w-100 d-inline-block text-truncate" title="正则表达式和RegExp对象" target="_blank"> 正则表达式和RegExp对象 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/4FCE89E80144DAC9" class="w-100 d-inline-block text-truncate" title="PHP 7 - Expectations" target="_blank"> PHP 7 - Expectations </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/6DEDBC8CF4A74CF2" class="w-100 d-inline-block text-truncate" title="Tableau - 基本过滤器" target="_blank"> Tableau - 基本过滤器 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/FBBCECB9408FB1A5" class="w-100 d-inline-block text-truncate" title="Sqoop - Job" target="_blank"> Sqoop - Job </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/0C4EA4591978C2F7" class="w-100 d-inline-block text-truncate" title="Amazon RDS - MariaDB创建数据库" target="_blank"> Amazon RDS - MariaDB创建数据库 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/B7CC2461A5343591" class="w-100 d-inline-block text-truncate" title="DB2 - 数据类型" target="_blank"> DB2 - 数据类型 </a> </li> <li class="list-group-item"> <a href="/detail/2022/1108/1EA16E42350684A8" class="w-100 d-inline-block text-truncate" title="XQuery - 第一个应用程序" target="_blank"> XQuery - 第一个应用程序 </a> </li> <li class="list-group-item"> <a href="/detail/2023/0306/766647EA6EE27A04" class="w-100 d-inline-block text-truncate" title="CSS padding-left 属性" target="_blank"> CSS padding-left 属性 </a> </li> <li class="list-group-item"> <a href="/detail/2023/0314/4085B46ABEAA3870" class="w-100 d-inline-block text-truncate" title="实例助你理解php递归函数原理及调用方法" target="_blank"> 实例助你理解php递归函数原理及调用方法 </a> </li> <li class="list-group-item"> <a href="/detail/2023/0319/73AB5F2F6128FA2E" class="w-100 d-inline-block text-truncate" title="HTML !DOCTYPE 声明" target="_blank"> HTML !DOCTYPE 声明 </a> </li> <li class="list-group-item"> <a href="/detail/2023/0414/3A0AD347C1AD1B06" class="w-100 d-inline-block text-truncate" title="jQuery UI 下载" target="_blank"> jQuery UI 下载 </a> </li> </ul> </section> </aside> </article> </main> </section> <footer class="footer"> <div class="container-fluid footer-widget"> <div class="container"> <div class="row"> <div class="col-12 col-md-4 col-lg-4"> <h3 class="text-start">幻海十年，专注互联网</h3> <ul class="d-flex px-0" style="text-align: left; flex-wrap: wrap"> <li class="item-3 mb-1"> <a target="_blank" href="https://wx.jonvie.com" rel="noopener noreferrer" title="几微助手"> <span>几微助手</span> </a> </li> <li class="item-3"> <a target="_blank" href="http://www.wonhero.com/" rel="noopener noreferrer" title="幻海官网"> <span>幻海官网</span> </a> </li> <li class="item-3"> <a target="_blank" href="http://www.rssso.com/" rel="noopener noreferrer" title="幻海优品"> <span>幻海优品</span> </a> </li> <li class="item-3 mb-1"> <a target="_blank" href="http://www.xct.cn" rel="noopener noreferrer" title="新彩天"> <span>新彩天</span> </a> </li> </ul> </div> <div class="col-12 col-md-4 col-lg-4"> <h3 class="text-start">关于</h3> <div class="text-start"> <span> 幻海科技成立于2009年，是一家集互联网基础技术服务、网络平台运营服务、软件产品研发、行业软件定制、自营电商平台于一体的专业互联网公司 </span> </div> </div> <div class="col-12 col-md-4 col-lg-4"> <h3 class="text-center">联系</h3> <div> <img src="http://www.jonvie.com/static/images/rightbar/QRcode.png?v=23" width="80" height="80" alt="微信公众号" /> </div> </div> </div> </div> </div> <div class="container-fluid" style="margin-top: 10px;"> <div class="row"> <div class="col-12 site-info"> <div class="item"> <a href="https://beian.miit.gov.cn/" target="_blank" rel="noopener external nofollow noreferrer"> 粤ICP备09219857号 </a> </div> </div> <div class="item">2009-2025 Copyright Wonhero.Com All Rights Reserved</div> <div class="item">深圳幻海软件技术有限公司 版权所有</div> </div> </div> </footer> <div id="toTop" style="display: none">返回顶部</div> <script src="//static.jonvie.com/wonhero/jquery/jquery.min.js"></script> <script src="//static.jonvie.com/wonhero/bootstrap/bootstrap.min.js"></script> <script> document.querySelectorAll('pre.prettyprint').forEach(el => { hljs.highlightElement(el); }); </script> <script> const total = Number("30"); let loading = document.querySelector(".loading"); loading.style.display = "none"; let currentpage = 2; let limit = 50; let isMore = total > limit; // 用于计算当前元素距离浏览器顶部距离 function getElementTop(el) { if (el.offsetParent ) { return getElementTop(el.offsetParent ) + el.offsetTop } return el.offsetTop } // 监听滚动条 document.addEventListener("scroll",init); // 临界点判断 function init(){ let scrollTop = document.body.scrollTop || document.documentElement.scrollTop // 滚动条 let sidebarTop = getElementTop(document.querySelector(".sort-sidebar")); let sidebarHeight = document.querySelector(".classify").offsetHeight; if (sidebarTop + sidebarHeight < (scrollTop + document.documentElement.clientHeight) && isMore) { getSideBar(currentpage, limit) // 请求数据 } } init(); // 获取数据 function getSideBar(page, limit) { try { isMore = false; fetch(`/api/ManagerApi/GetPageArtitlesByCls?page=${page}&limit=${limit}&channel=devdoc&clsId=810595E586D3DB44`) .then(resp => resp.json()) .then(res => { if (res.Success) { isMore = (page - 1) * limit + res.Data.Item2.length < total; if (isMore) currentpage += 1; renderSidebar(res.Data.Item2); // 渲染列表 } }); } catch (e) { console.log(e, 23) } } // 渲染列表 function renderSidebar(list = []) { if (!list.length) return; let template = list.map(item => { return `<li class="list-group-item" style="border: 0px"> <a class="w-100 d-inline-block text-truncate" title="${item.ContentTitle}" href="/detail/${item.ContentID}" target="_blank"> ${item.ContentTitle} </a> </li>` }).join(""); document.querySelector(".classify").innerHTML = document.querySelector(".classify").innerHTML + template; } </script> <script> ;(()=>{ var height = $(window).height(); $(window).scroll(function() { if ($(window).scrollTop() > height) { $("#toTop").fadeIn(500); } else { $("#toTop").fadeOut(500); } }); $("#toTop").click(function() { $('body,html').animate({ scrollTop: 0 }, 500); return false; }); })(); </script> <script> var _hmt = _hmt || []; (function () { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?843cad737da0ae856cb26e84eafcd9bb"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script> <script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script> <script>LA.init({ id: "Jzndc69N7BtnPgpT", ck: "Jzndc69N7BtnPgpT" })</script> </body> </html>