mysql> drop database testdb;
ERROR 1010 (HY000): Error dropping database (can't rmdir './testdb/', errno: 17)
mysql> select @@datadir;
+------------------------+
| @@datadir |
+------------------------+
| /usr/local/mysql/data/ |
+------------------------+
ERROR 1010 (HY000): Error dropping database (can't rmdir './testdb/', errno: 17)
mysql> select @@datadir;
+------------------------+
| @@datadir |
+------------------------+
| /usr/local/mysql/data/ |
+------------------------+
1 row in set (0.00 sec)
原因是数据/usr/local/mysql/data/ 目录下有除了数据库文件以外的文件, 可以cd到其目录,清空后。再drop
[root@localhost104 data]# cd testdb
[root@localhost104 testdb]# ll
total 0
-rw-r--r-- 1 root root 0 Jul 23 10:22 delete.txt
[root@localhost104 testdb]# rm delete.txt
rm: remove regular empty file ‘delete.txt’? yes
mysql> drop database testdb;
Query OK, 0 rows affected (0.06 sec)
数据库目录不能存放与数据库无关的文件!