MY SQL - Error Code: 1010. Error dropping database (can't rmdir; errno: 13)

Question

When trying to drop a database in MySQL

'DROP DATABASE IF EXISTS temporarydata'

I am getting the following error

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

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?

Execute this : Grant drop execute on *.* to 'your-user-name'@'user-ip'; — Sathish D, Jan 28 '14 at 10:54
Check this out. This is on the stack overflow.. http://stackoverflow.com/questions/12196996/mysql-error-dropping-database-errno-13-errno-39 — tarzanbappa, Jan 28 '14 at 11:00

score 3 · Answer 1 · answered Jan 28 '14 at 10:56

3

Errno 13

MySQL has no write permission on the parent directory in which the temporarydata folder resides.Check it out

A database is represented by a directory under the data directory, and the directory is intended for storage of table data.

The DROP DATABASE statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove the directory.

MySQL displays an error message when it cannot remove the directory, you can really drop the database manually by removing any remaining files in the database directory and then the directory itself.

answered Jan 28 '14 at 10:56

Abdul Manaf

4,768
3
27
34

Hi thanks for this, however it doesn't allow for me to remove the directory manually. Says I don't have permission. Have you an idea how to give the parent directory write permission? – user3244139 Jan 28 '14 at 11:02
Hope this will help you http://answers.microsoft.com/en-us/windows/forum/windows_vista-files/how-do-i-change-folder-and-file-permissions/465f2b42-63dd-4486-8dd1-c870290efeed – Abdul Manaf Jan 28 '14 at 11:03
I have followed the instructions and changed the permissions, however I still get the errno 13 error message and i'm unable to delete manually as it says I need administrators permission even though I am an administrator. – user3244139 Jan 28 '14 at 11:17
I Don't know much about windows,If it was Linux i can help you out – Abdul Manaf Jan 28 '14 at 11:33

score 3 · Answer 2 · answered Sep 25 '15 at 03:44

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.

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.)

You can see in there the folder of that database (eg. temporarydata).

Delete that folder.

Rerun your sql script.

drop database temporarydata;

Hope this helps.

score 1 · Answer 3 · answered Jan 19 '19 at 05:09

1

If you use wampserver and mariadb you can go directly here and delete the folder of your database :

C:\wamp64\bin\mariadb\mariadb10.2.8\data

answered Jan 19 '19 at 05:09

Amin Arjmand

435
7
21

score 0 · Answer 4 · answered Apr 06 '20 at 20:56

I experienced the same problem. I am describing below my solution:

mysql> DROP DATABASE mydatabase;
ERROR 1010 (HY000): Error dropping database (can't rmdir '.\mydatabase', errno: 13)

I went to delete this directory: C:\Users\jaimemontoya\...\core\mysql\data\mydatabase.

mysql> DROP DATABASE mydatabase;
ERROR 1008 (HY000): Can't drop database 'mydatabase'; database doesn't exist

mysql> CREATE DATABASE mydatabase;
Query OK, 1 row affected (0.00 sec)

That created again folder C:\Users\jaimemontoya\...\core\mysql\data\mydatabase containing this file: db.opt.

mysql> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> exit
Bye

After the database was created, I imported data to the database and my C:\Users\jaimemontoya\...\core\mysql\data\mydatabase was populated with many more files. Three files per table of my database using the following extensions:

[table].frm
[table].MYD
[table].MYI

score 0 · Answer 5 · answered May 13 '22 at 11:26

0

Manually delete database in C drive->Mysql Folder->data Folder-> your database name

it works for me hope it will work for you

answered May 13 '22 at 11:26

Arpit Tyagi

1
2

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – another victim of the mouse May 13 '22 at 20:51

score 0 · Answer 6 · answered Sep 03 '22 at 04:52

0

For Mac users go to path:

/Applications/XAMPP/xamppfiles/var/mysql/NAMEOFDATABASE

and delete it manually

answered Sep 03 '22 at 04:52

Ridha Rezzag

3,672
1
34
39

MY SQL - Error Code: 1010. Error dropping database (can't rmdir; errno: 13)

6 Answers6

Linked