MySQL – drop database return “Error dropping database errno: 66”

I found some similar threads on SO, but none of them helped me.

The problem is, that I don't know where the file/directory is located - in /usr/local/mysql/bin/ is this file missing...

Could you help me, please, how to fix this issue?

Answers

  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")

If you are using XAMPP in OSX the data directory would be at

http://tiku.io/questions/160940/mysql-drop-database-return-error-dropping-database-errno-66