MY SQL-错误代码:1010.删除数据库时出错(无法rmdir； errno:13)

问题描述

当尝试在MySQL中删除数据库

When trying to drop a database in MySQL

'DROP DATABASE IF EXISTS temporarydata'

我遇到以下错误

Error Code: 1010. Error dropping database (can't rmdir '.\temporarydata', errno: 13)

我已经对此进行了研究，我认为这可能是一个许可问题，但是我发现的所有修复程序都是针对linux计算机的.有谁知道如何在Windows 7中解决这个问题?

I have researched into this and I think it may be a permission issue, however all the fixes I have found have been for linux computers. Has anyone got any idea how to sort this out in windows 7?

推荐答案

自创建该线程以来，我已经知道它已经一年多了，但我想我应该向您分享我在此问题和解决方案上的经验.请注意，它适用于在Windows 7中使用MySQL Workbench的用户.

I know its over 1 year since this thread was created but I think I should share to you my experience with this problem and the solution I've made. Note, its for those who uses MySQL Workbench in Windows 7.

1. 转到目录C:\ ProgramData \ MySQL \ MySQL Server 5.6 \ data(在某些情况下，如果看不到ProgramData文件夹，请取消隐藏 首先使用文件夹"和搜索"选项.)
2. 您可以在其中看到该数据库的文件夹(例如，临时数据).
3. 删除该文件夹.

4. 重新运行您的sql脚本.

1. Go to the directory C:\ProgramData\MySQL\MySQL Server 5.6\data (In some instances, if you cannot see the ProgramData folder, then unhide it first using the Folder and search options.)
2. You can see in there the folder of that database (eg. temporarydata).
3. Delete that folder.

4. Rerun your sql script.

删除数据库临时数据；

drop database temporarydata;

希望这会有所帮助.

这篇关于MY SQL-错误代码:1010.删除数据库时出错(无法rmdir； errno:13)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！