MySQL encountered a problem: can ' t creat/write to File "/var/mysql/xxxx. MYI "

This problem bothers me, there may be two reasons.

1, folder permissions are not enough, at least also to give the USERS group's readable writable permission;

2. The disk of the folder is full, the file is not written in;

If this is a problem that cannot be created or written, a large probability is the permissions of the file. There's not a whole bunch of explanations online.

Change method:

1 #chown-R mysql:mysql/usr/local/mysql/Changing the read and write permissions of the user group note the folder path here.

More than 2 should be able to solve the problem, if not resolved

In addition to the directory authorization, but also to modify the context of the directory security

Chcon-r-T Mysqld_db_t/home/myusqldata

MySQL encountered a problem: can ' t creat/write to File "/var/mysql/xxxx. MYI "