Skip to content

ERROR 1017 (HY000): Can’t find file: ‘./….frm’ (errno: 13) – MySQL error. How to fix?

In this post we will take a look at resolving the MySQL error – ERROR 1017 (HY000): Can’t find file: ‘./….frm’ (errno: 13). Error no 13 is is probably due to Permission denied by MySQL. 

The main reason for the MySQL error – ERROR 1017 (HY000): Can’t find file: ‘./….frm’ (errno: 13) is you don’t have the write permission in your mysql data directory. Please check your permission to write in that folder.

To fix this error, change the owner of your MySQL data directory to mysql user and mysql group using the following command.

chown -R mysql:mysql your-mysql-data-dir-here

The default data directory of MySQL would be /var/lib/mysql.

chown -R mysql:mysql /var/lib/mysql

See also  How to get the size of the database in PostgreSQL?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.