Search code examples
mysqlmysql-error-1064

MySQL no longer shows error message, only code

Since I upgraded to MYSQL 5.7.16, I no longer have error messages, which is annoying (I now have to remember all codes) and gets very very annoying when it comes to SQL 1064 (Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) %s near '%s' at line %d says the doc... so easy to debug with no info nor line number).

Same goes for warnings: if a line returns a warning, I can no longer read it (show warnings doesn't crash, but it returns no result).

So I bet (hope!) MySQL made a configuration change: what's the option to get the MySQL error messages back?

Solution

  • The problem is related to the lc-messages-dir directive. In last versions, the default dir is wrong (at least under Debian).

    Put this into your mysql.cnf : 

    lc-messages-dir = /usr/share/mysql/english/

    And error messages will be back ;)