CODEWITHSUNDEEP
mysqlmacosmysql-workbench
user99244
user99244

Reputation: 13

Getting Error 1010 while dropping a Database on MySQL Workbench on Mac OS

I am getting the following error while dropping a database on MySQL Workbench on Mac OS X 10.8.2.

Error 1010: Error dropping database (can't rmdir './nssj', errno: 66) SQL Statement: drop schema NSSJ

I tried to search for this dir in /usr/local/mysql but I am not to find it.

Can any one tell me what I am missing here?

Upvotes: 0

Views: 4569

Answers (3)

Monika Rani
Monika Rani

Reputation: 841

Delete database from the Directory bin/mysql/mysql5.6.12/data

mysql5.6.12 is my mysql version it depend upon your mysql version

Upvotes: 2

CAtoOH
CAtoOH

Reputation: 81

The chances are you are not running within an administrator's account; you don't have permission to delete the directory.

  1. In your finder menu bar click "go" and type the following: usr/local/mysql/data
  2. Select/delete the directory with the same database you want to drop - you will likely get the dialog asking for the admin username and password to continue.
  3. After you enter the admin credentials, the directory will be gone. Restart your session with the database and you will be good to go.

Hope this helps

Upvotes: 0

Meherzad
Meherzad

Reputation: 8553

Stop the sql workbench

1)Remove db -> /usr/local/mysql/bin/mysql (the one which you want to delete)

2) Go to DB folder: cd /usr/local/mysql/data/

3) Delete DB folder of DB with issue

Start your workbench

Upvotes: 1

Related Questions