Bug #101521 The user/group permission should be specified about system variable 'datadir'

• Submitted: 9 Nov 2020 7:35
• Modified: 10 Nov 2020 17:36
• Reporter: Zhou Shu
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[9 Nov 2020 7:35] Zhou Shu

Description:
The user/group permission about the datadir is not mentioned in (https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_datadir). 

How to repeat:
If use a directory owned by other users as datadir, that current user don't has the permission, the log get an error about this on my platform and it indicates that "Can't read data directory's stats. Assuming that it's not owned by the same user/group". So I suggest that this information could be added in the document.

[9 Nov 2020 9:02] MySQL Verification Team

Hello Zhou Shu,

Thank you for the report and feedback.

regards,
Umesh

[10 Nov 2020 17:36] Paul DuBois

Posted by developer:
 
Similar considerations apply to datadir or any other system variable related to placement of files/directories within the MySQL deployment. Information about permissions is better found in the how-to-install documentation. For example:

https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html