Tuesday, 4 October 2011

#6 - Error on delete of './database' (Errcode: 13)

Some times, we will get the following error when we try to drop the database from PHP my admin.

========
Error
SQL query:
DROP DATABASE `databasename`
MySQL said:
#6 - Error on delete of './databasename' (Errcode: 13)
========

The problem is with wrong permission of /var/lib/mysql. You can fix the issue by changing the permission of mysql data directory to mysql .

#chown mysql.mysql /var/lib/mysql.

Now, you are able to drop the database from PHP my admin.

No comments: