Change MySQL error message language

Question

I have problem with MySQL Error Language. When query has some error then that error is not in English. It is like below message

Le champ 'id' ne peut être vide (null) 

I have run this query to change language but still same error

SET lc_messages = 'en_US';

How can I change error message to English?

Answer 1

Change the following settings in my.ini file

lc-messages=en_US

To permanently change the language preferences

Answer 2

Change the following settings in my.ini file