Software⏱️ 3 min read📅 2026-06-03

How to Fix: Error Dropping Database (Can't rmdir '.test\', errno: 17)

MySQL error dropping database due to file system issue.

Quick Answer: Try running the command with elevated privileges using 'runas' or 'powershell' as administrator.

📋 Table of Contents

  1. 🔍 Why This Happens
  2. 🔧 Proven Troubleshooting Steps
  3. 🎯 Final Words

The Error Dropping Database issue occurs when attempting to delete a database that is still in use by the MySQL server. This error affects users who have created databases using the MySQL command-line interface or other tools, and are now trying to drop one of those databases.

This error can be frustrating because it prevents users from cleaning up their database schema, which can lead to confusion and inefficiencies. Fortunately, this issue can be resolved by identifying and resolving the issues preventing the database from being dropped.

🔍 Why This Happens

  • The primary reason for this error is that the MySQL server still has a lock on the database file, preventing it from being deleted or dropped. This can happen when the database was created using the `CREATE DATABASE` command without specifying the `ENGINE` parameter, which causes MySQL to use the default engine (MyISAM) and leave a lock on the file.
  • Alternatively, if the database was created with the `CREATE DATABASE` command but not properly closed or terminated before attempting to drop it, MySQL may also retain a lock on the file.

🔧 Proven Troubleshooting Steps

Using the MySQL Command-Line Client

  1. Step 1: Open the MySQL command-line client and enter the following command: `SHOW PROCESSLIST;` This will display a list of all active connections to the MySQL server, including any locks held on databases.
  2. Step 2: Look for the database in question and identify its corresponding process ID. Note down this process ID as you will need it later.
  3. Step 3: Enter the following command: `KILL ;` This will terminate the process holding the lock on the database file, allowing you to drop the database.

Using the MySQL Server Log Files

  1. Step 1: Check the MySQL server log files (usually located in `C:\Log iles` or similar) for any entries related to the database in question. These logs may indicate which process is holding the lock on the file.
  2. Step 2: Look for lines that contain the database name and a lock indicator (`LOCK TABLES ...`) This will help you identify which process has the lock and take steps to resolve it.

🎯 Final Words

To summarize, the Error Dropping Database issue can be resolved by identifying and resolving the issues preventing the database from being dropped. By using the MySQL command-line client or reviewing server log files, users can determine which process is holding the lock on the file and take steps to terminate it, allowing them to drop the database successfully.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Pc crashes shortly after launching game (rainbow

Fix Pc crashes shortly after launching game (rainbow six siege). Compl

How to Fix: Installing an APK on a locked down phone

Installing an APK on a locked down phone: Try using a rooted device, e

How to Fix: New PC build- no signal and no clue

Fix New PC build- no signal and no clue. Complete troubleshooting guid