Error dropping database (can't rmdir '.\abm', errno: 41) on windows in mysql server

1 year ago
6

A database is represented by a directory under the data directory (usually /var/lib/mysql), and the directory is intended for storage of table data.

The DROP DATABASE statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove the directory.

MySQL displays an error message when it cannot remove the directory

you can really drop the database manually by removing any remaining files in the database directory and then the directory itself.

🔖address:
C:\Program Files (x86)\Ampps\mysql\data
C:\Program Files (x86)\Xampp\mysql\data

Loading comments...