MySQL 8 server errors

This section focuses on MySQL 8 server errors. The section describes the errors related to MySQL server administration, table definitions, and known issues in the MySQL 8 server.

Issues with file permissions

If the UMASK or UMASK_DIR environment variables are set incorrectly upon server startup, we may have problems with file permissions. The MySQL server may issue following error message upon table creation:

ERROR: Can't find file: 'path/with/file_name' (Errcode: 13)

The default values for UMASK and UMASK_DIR system variables are 0640 and 0750, respectively. If the value of these environment variables starts with zero, it indicates to the MySQL server that the values are in octal. For example, the default values 0640 and 0750 in octal are equivalent to 415 and 488, respectively, in decimal.

In order to change the default UMASK value, we should start mysqld_safe, as follows:

> UMASK=384# = 600 in octal
> export UMASK 
> mysqld_safe

The MySQL server creates database...