Troubleshoot MySQL error 1017:can t find file resolve error

Source: Internet
Author: User
Tags mysql tutorial file permissions

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.