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”
Leave a Reply