DROP DATABASE db_name; ERROR 1010 (HY000): Error dropping database (can't rmdir './db_name', errno: 66)
The problem is that I don’t know where the file/directory is located – this file is missing in /usr/local/mysql/bin/…
How do I fix this issue?
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
mysql> drop database DB_NAME; ERROR 1010 (HY000): Error dropping database (can't rmdir './DB_NAME', errno: 66)
Find the database directory:
mysql -e "select @@datadir"->
Go to the DataBase folder:
Delete DB folder of the DB with the issue (in this case:
sudo rm -rf DB_NAME)
If you are using XAMPP in OSX the data directory would be at
FYI for mac users with normal mysql server:
/usr/local/mysql/bin/mysql -u root -pPASSWORD -e "select @@datadir"