How to fix MySQL error (Errcode: 13 - Permission denied) when creating a table with DATA DIRECTORY = 'path'?

Question

linux

Variable value datadir = /var/lib/mysql/ Trying to create a table specifying a different data storage location (on a different disk partition) using DATA DIRECTORY = 'path' gives error
#1 - Can't create/write to file 'path' /table_name.MYD' (Errcode: 13 - Permission denied)
follow the instructions https://dev.mysql.com/doc/refman/8.0/en/tablespace...

Answer 1

Give the user running the mysqld process read/write permissions on this directory
chown + chmod