首页 > 数据库技术 > 详细

ERROR 6 (HY000): ERROR ON DELETE OF ‘./DATABASE//DB.OPT’ (ERRCODE: 13)

时间:2015-03-12 15:23:03      阅读:1954      评论:0      收藏:0      [点我收藏+]

I was trying to drop a database in MySQL today but every time I did I got the error:

ERROR 6 (HY000): Error on delete of ‘./database//db.opt‘ (Errcode: 13)

This was due to the fact permissions on the database folder were not allowing MySQL to delete the folder.

There are a couple of ways you can fix this, either through the command line by finding the folder in question and changing the permissions to allow the MySQL user permissions, or through your FTP application, I am using WinSCP. Simply navigate to where you store your MySQL databases, right click on the folder in question and set the MySQL user to have read, write and execute permissions. You will now be able to drop the database.

总结起来就一句话,看看mysql的数据目录权限。

ERROR 6 (HY000): ERROR ON DELETE OF ‘./DATABASE//DB.OPT’ (ERRCODE: 13)

原文:http://dihuo.blog.51cto.com/1657091/1619622

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!