MySQL Workbench not allowing for me to drop a database

Question

This is quite odd, it's happening only for a some Databases, but I get this error:

ERROR 1010: Error dropping database (can't rmdir './main', errno: 66)
SQL Statement:
drop database `Main`

This happens over and over, even on Root user...

This happens even if there is nothing in the database.

http://stackoverflow.com/questions/16527054/mysql-drop-database-return-error-dropping-database-errno-66 — Hanky Panky, Jan 02 '14 at 06:35
Possible duplicates of http://stackoverflow.com/questions/4584458/error-dropping-database-cant-rmdir-test-errno-17 — gipinani, Jan 02 '14 at 06:35

score 0 · Answer 1 · edited May 23 '17 at 10:32

0

mysql> drop database DB_NAME; 
ERROR 1010 (HY000): Error dropping database 
(can't rmdir './DB_NAME', errno: 66)

1) mysql -e "select @@datadir" -> /usr/local/mysql/bin/mysql

2) Go to DB folder: cd /usr/local/mysql/data/

3) Delete DB folder of DB with issue (in this case: "DB_NAME")

edited May 23 '17 at 10:32

Community

answered Jan 02 '14 at 06:40

Nagaraj S

You literally copied that, and I said it didn't work in the questions comments. – Jan 02 '14 at 06:41

score 0 · Accepted Answer · answered Jan 02 '14 at 06:43

0

I figured out, and it wasn't all that hard, using the OS X terminal I entered this in:

open /usr/local/mysql/data/

then, I just deleted the folders. An admin password was required though.

Thanks to anyone that offered to help

answered Jan 02 '14 at 06:43

I got this `The file /usr/local/mysql/data does not exist.` when running your command. – code-8 Oct 21 '15 at 13:08
@ihue This was posted like 1.75 years ago. I don't use Mac OS anymore and MySQL could have updated and changed by then. Try looking at the posts linked in the comments of the question, or try the answer below. – Oct 21 '15 at 14:20

2 Answers2