ERROR 1010 (HY000): Error dropping database (can't rmdir './test/', errno: 17)
Database Error HY000 39 17 can test
2023-09-27 14:22:16 时间
在删除数据库的时候报标题所示错误
mysql> drop database test; ERROR 1010 (HY000): Error dropping database (can't rmdir './test/', errno: 17)
问题原因:
test目录下存在着MySQL数据库不知道的文件,即MySQL数据库中没有该文件的数据字典信息。
如下所示,
[root@localhost data]# cd /usr/local/mysql-advanced-5.6.23-linux-glibc2.5-x86_64/data/test [root@localhost test]# ls 123
解决方法:
手动删除test目录下的该文件
# rm -rf 123
登录数据库,重新执行drop database操作
mysql> drop database test; Query OK, 0 rows affected (0.01 sec)
相关文章
- 【高效编码】IDEA的常用插件(二)!!!,非常实用(DataBase,VisualVM Launcher等等)
- Unexpected error from external database driver (1)
- 倍福--Database的安装
- Driver is connected to the database that does not support driver reactive API. In order to use the driver reactive API, please upgrade to neo4j 4.0.0 or later.
- Docker Oracle DataBase
- Debain-8.11 安装 oracle 11.2.0.4 数据库database软件
- HTML5客户端数据存储机制Web Storage和Web SQL Database
- Mysql - 解决Access denied for user ''@'localhost' to database 'mysql'问题
- How To Decrypt WeChat EnMicroMsg.db Database?
- Memory Architecture-SGA-Database Buffer Cache
- Oracle Database 18c 的10大新特性一览
- 已解决java.sql.SQLNonTransientConnectionException:Could not create connection to database server异常的正确解决
- An attempt to attach an auto-named database for file
- DataError: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
- Create schema error (unknown database schema '')
- Oracle数据库如何授权收费(Database Licensing)
- 一次org.springframework.jdbc.BadSqlGrammarException ### Error querying database Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException问题排查过程
- Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
- ORA-38760: This database instance failed to turn on flashback database 错误解决过程