本文介绍了删除数据库返回“错误删除数据库errno:66".在MySQL中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
考虑:
DROP DATABASE db_name;
ERROR 1010 (HY000): Error dropping database (can't rmdir './db_name', errno: 66)
问题是我不知道文件/目录的位置-/usr/local/mysql/bin/ ...
The problem is that I don't know where the file/directory is located - this file is missing in /usr/local/mysql/bin/...
如何解决此问题?
推荐答案
mysql> drop database DB_NAME;
ERROR 1010 (HY000): Error dropping database
(can't rmdir './DB_NAME', errno: 66)
-
查找数据库目录:
mysql -e "select @@datadir"
->/usr/local/mysql/data/
Find the database directory:
mysql -e "select @@datadir"
->/usr/local/mysql/data/
转到数据库"文件夹:cd /usr/local/mysql/data/
Go to the DataBase folder: cd /usr/local/mysql/data/
删除有问题的数据库的DB文件夹(在本例中为sudo rm -rf DB_NAME
)
Delete DB folder of the DB with the issue (in this case: sudo rm -rf DB_NAME
)
这篇关于删除数据库返回“错误删除数据库errno:66".在MySQL中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!