ERROR 1010 (HY000) at line 1: Error dropping database

时间:2022-03-20 21:11:07

MySQL5.5.20 中删除test数据库时遇到如下错误,ERROR 1010 (HY000) at line 1: Error dropping database (can't rmdir './test/', errno: 17)

mysql> select VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.20-log |
+------------+
1 row in set

$./mysql_secure_installation
Remove test database and access to it? [Y/n] y
 - Dropping test database...
ERROR 1010 (HY000) at line 1: Error dropping database (can't rmdir './test/', errno: 17)
 ... Failed!  Not critical, keep moving...
 - Removing privileges on test database...
 ... Success!
 

原来在mysql 的data/test中有隐藏文件.empth,  手工删除这个隐藏文件后可以drop掉test库。
$ls -la
total 20
drwxrwxr-x  2 mysql mysql 4096 2014-12-17 15:03:27 .
drwxrwxr-x 10 mysql mysql 4096 2015-01-13 01:12:13 ..
-rw-r--r--  1 mysql mysql    0 2012-06-18 18:40:07 .empty

$rm -rf .empty

mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)