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

[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] MySQL Verification Team 
Hello Karl-Philipp,

Thank you for the feature request.

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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.