Can't DROP tables or database 1

[PracticalProgra]

Newbie. Loaded mySQL. Appears to work fine, except when I want to DROP a table, or a database.

For instance, if I CREATE a database and then I type DROP DATABASE KensDB, I get the following error:

ERROR 1009: Error dropping database (can't delete '.\KensDB\#sql-300_6.frm'.errno:473312)

There is nothing in the database, I havn't done anything yet. I can kill the database by deleting it's folder, but that's not right.

Any ideas?

 

[williamu]

Hi,

What does SHOW DATABASES; return?


William
Software Engineer
ICQ No. 56047340

 

[PracticalProgra]

Thanks for writing back, but . . .

nevermind.

Turned out to be a permissions problem.

Thanks again.

Ken

 

[sleipnir214]

PracticalProgra:
Please expound. Some other TT member might find your experience useful.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[PracticalProgra]

Good point sleipnir.

In investigating the problem, I noticed, when I went to the "Security" tab on the "Properties of the "DATA" directory beneath the "mySQL" directory, that "AUTHENTICATED USERS" did not have certain permissions on that directory. I gave them "Full Control" and now everything works.

Obviously, one would want to be more judicious with the application of the "Full Control" security, but, at least, it identified that the problem was a permissions issue.

Thanks.

 

[xutopia]

a star for expounding!

Gary

http://www.xutopia.com

Haran
********************************