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 the secure_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.