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  bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?] Spring Boot / Spring Batch error. How to fix?

Leave a Reply

Your email address will not be published.

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