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

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的数据目录权限。

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。