Bug #78797 Add info which directory is missing permissions in error message
Submitted: 11 Oct 2015 18:16 Modified: 15 Oct 2015 11:15
Reporter: Karl-Philipp Richter Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6 OS:Linux
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[11 Oct 2015 18:16] Karl-Philipp Richter
Description:
Missing write or other file permissions can cause an error message in the form of 

    InnoDB: Operating system error number 13 in a file operation.
    InnoDB: The error means mysqld does not have the access rights to
    InnoDB: the directory.

which is relatively useless without the info which directory is meant

How to repeat:
Stop MySQL, remove `w` permission of owner and group from all files of a database directory in the MySQL data directory and restart the service.

Suggested fix:
The error message should be 

    InnoDB: Operating system error number 13 in a file operation.
    InnoDB: The error means mysqld does not have the access rights to
    InnoDB: the directory /path/to/directory (was r--r------ should be rw-rw-----).
[15 Oct 2015 11:15] Umesh Shastry
Hello Karl-Philipp,

Thank you for the feature request.

Thanks,
Umesh
[15 Oct 2015 11:15] Umesh Shastry
Also, see related Bug #76020