MySQL Error 1017 (HY000): Can’t find file
Problem: When run mysql command “show tables”, I got the error
1 |
ERROR 1017 (HY000): Can't find file: 'xxxxx.frm' (errno: 13) |
But in fact the file xxxxx.frm really exists on the mysql data directory, how to resolve the problem. Solutions: I have do some research and find that there are 2 tips to resolve the problem: Check file permission
1 |
chown -R mysql:mysql your-mysql-data-dir-here |
Make sure that your MySQL data […]