Steven Henty

Developer

  • Facebook
  • LinkedIn
  • Twitter
  • Blog
  • Profile
  • Products
  • Contact
© 2023 Steven Henty

Local Lightning: MySQL v5.7 not returning errors

December 7, 2020 by Steven Henty Leave a Comment

Problem

MySQL v5.7 on Local Lightning doesn’t return helpful error messages. e.g. “Unknown error 1054” instead of “ERROR: Unknown column ‘foo’ in ‘field list‘”. In the case of a typo in a keyword e.g. “sssselect foo from wp_options” no errors are returned at all.

From the Local Lightning log:
Can’t find error-message file ‘/usr/local/mysql/share/errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive.

Solution

Add the following line to the MySQL config file for the site.

lc-messages-dir = “~/Library/Application Support/Local/lightning-services/mysql-5.7.28+4/bin/darwin/share”

Filed Under: Blog

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *