WAMP / MySQL errors do not match the correct language

Question

I reinstalled WAMP several times, looked for literally hundreds of pages and did not fix this problem:

I looked into the phpmyadmin configuration files, installed:

$cfg['Lang'] = 'en-utf-8'; 

It was deleted several times (as mentioned) and it seemed unlucky that it was. Any help would be greatly appreciated.

Answer 1

To change the language used by MySQL when creating reports, you need to modify the my.ini file as follows.

Find this line:

 # Change your locale here ! lc-messages=fr_FR 

And change it to your preferred language, for example:

 lc-messages=en_GB 

To change it to English in the USA, you can do the following:

 lc-messages=en_US 

Save the file and then restart MySQL.

 left click wampmanager icon -> MySQL -> Service -> Restart Service 

Remember that the guys who make WampServer are French, so I think it was added to the my.ini file and they just forgot to delete it in this version.

How to find my.ini in WAMPServer

Use the wampmanager menu as follows: -

 left click wampmanager icon -> MySQL -> my.ini 

This will load the my.ini file into your editor.

Here you can find a list of valid locales.

Answer 2

Change the following settings in my.ini file

 lc-messages=en_US 

To constantly change the language settings

Answer 3

$cfg['Lang'] = 'en-utf-8'; and friends change the language for phpmysql and not for mysql server, so nothing from the database server will be affected.

You need to start the server daemon with --lc_messages=en_US (or put it in the corresponding configuration file), to configure per session just use SET lc_messages = 'en_US';