Troubleshoot MySQL error 1017:can t find file resolve error

Check on the Internet most people are said to be the issue of permissions, the following we told two kinds of MySQL tutorial 1017 wrong solution, friends can refer to.

ERROR 1017 (HY000): Can ' t find file: (errno:13)

The reason is that the MySQL database tutorial file does not have read and write permissions

In the case of Debian systems, general data files are placed under/var/lib/mysql

The permissions for the database directory are rwx--, and the owner is MySQL

The file permissions under the database directory are 660 (rw-rw-), and the owner is also MySQL

Method Two

If the MyISAM table does not shut down Mysql,mysql before restarting the server, it is likely that the error #1017: Can ' t find file: '/xxx.frm ',

The reason for this problem is not that the '/xxx.frm ' file is missing, but that the file's permissions (which should be MySQL) do not know why it became root.

Workaround: CD to xxx.frm file in the directory, to execute the command: Chown Mysql.mysql * will all the permissions of the file to change over it!