Troubleshooting MySQL Permissions
View MySQL Error Logs
To view the error log file, these conditions must be met:
secure_file_priv
is either empty or the name of the folder containing the error log file. You must restart MySQL for changes in thesecure_file_priv
variable to take effect.- The error log file is readable to all users.
max_allowed_packet
is larger than the error log file size.- The user has FILE privileges.