DROP DATABASE [IF EXISTS] db_name;
IF EXISTS:避免數據庫不存在時拋錯,僅產生警告。DROP 權限。mysql -u root -p
-- 進入交互模式後
DROP DATABASE IF EXISTS xhkdb;
mysql> DROP DATABASE drop_database;
Query OK, 0 rows affected (0.00 sec)
mysql> DROP DATABASE drop_database;
ERROR 1008 (HY000): Can't drop database 'drop_database'; database doesn't exist
mysql> DROP DATABASE IF EXISTS drop_database;
Query OK, 0 rows affected, 1 warning (0.00 sec)
-- Warning: 1008 Can't drop database 'drop_database'; database doesn't exist
mysqladmin -u root -p drop TUTORIALS
[root@host]# mysqladmin -u root -p drop TUTORIALS
Enter 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] y
Database "TUTORIALS" dropped
適用場景: Shell 腳本自動化部署、CI/CD 流水線、無法進入交互式 mysql 客戶端的環境。
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'rootpassword';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if (!$conn) {
die('連接失敗: ' . mysqli_connect_error());
}
$sql = 'DROP DATABASE IF EXISTS TUTORIALS';
if (mysqli_query($conn, $sql)) {
echo "數據庫 TUTORIALS 刪除成功\n";
} else {
die('刪除失敗: ' . mysqli_error($conn));
}
mysqli_close($conn);
?>
⚠️ 關鍵警告: PHP 腳本**無交互確認**,執行即刪除。生產環境嚴禁直接暴露此類接口,必須加雙重驗證(Token、IP 白名單、二次確認頁面)。
DROP 權限,不給全局 DROP。mysqldump 完整備份。RENAME DATABASE old_db TO old_db_deleted_20240101(MySQL 不直接支持 RENAME DATABASE,可用 RENAME TABLE 逐表移動或建新庫遷移)。audit_log 記錄所有 DDL 操作。| 錯誤碼 | 原因 | 解決 |
|---|---|---|
| 1008 | 數據庫不存在 | 加 IF EXISTS 或先創建 |
| 1010 | 刪除數據庫目錄失敗 | 檢查文件系統權限、磁盤空間、SELinux |
| 1051 | 表不存在(隱式事務中) | 檢查是否有殘留表文件 |