Local Lightning: MySQL v5.7 not returning errors

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”