WAMP/MySQL errors not in correct language
Solution 1
To change the language that MySQL uses when reporting you need to change the my.ini
file as follows.
Find this line:
# Change your locale here !
lc-messages=fr_FR
And change it to your prefered language, for example:
lc-messages=en_GB
To change it to English US, you can do like this:
lc-messages=en_US
Save the file and then restart MySQL.
left click wampmanager icon -> MySQL -> Service -> Restart Service
Remember the guys that produce WampServer are French so I guess thats why this has been added to the my.ini
file, and they just forgot to remove it on this release.
How to Find my.ini in WAMPServer
Use the wampmanager menus like so :-
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
Solution 2
Change the following settings in my.ini file
lc-messages=en_US
To permanently change the language preferences
Solution 3
$cfg['Lang'] = 'en-utf-8';
and friends change the language for phpmysql, not for the mysql server, so anything coming from the database server itself will be unaffected.
You need to start the server daemon with --lc_messages=en_US
(or put that in the relevant config file), for a per-session setting just use SET lc_messages = 'en_US';
![Dobby](https://i.stack.imgur.com/yRGrJ.jpg?s=256&g=1)
Dobby
Updated on July 05, 2022Comments
-
Dobby almost 2 years
I've re-installed WAMP multiple times, searched literally hundreds of pages, and its not fixed this issue:
I've looked inside the phpmyadmin config files, set:
$cfg['Lang'] = 'en-utf-8';
Uninstalled multiple times (as mentioned) and seemed to have no luck what so ever. Any help would be appreciated.
-
Dobby about 10 yearsHow do i do the
--lc_messages=en_US
in windows? :S -
Eugen Rieck about 10 yearsIIRC you just put it into
my.ini
ormy.cnf
, whatever you have, in the[mysqld]
section, likelc_messages = en_US
, ofcourse you need to restart the server. Haven't used Windows in a long time, though. -
Dave over 9 yearsSearching for the command may be easier as it is not on the first few lines. Thanks for the solution.
-
James Wilson over 9 yearsI set mine to: lc-messages=morse_CODE and now my errors are coming out like this: -.-- --- ..- / .... .- ...- . / .- -. / . .-. .-. --- .-. / .. -. / -.-- --- ..- .-. / -- -.-- ... --.- .-.. / ... -.-- -. - .- -..-
-
RiggsFolly over 9 years@JamesWilson Whatever floats your boat
-
Ryan over 9 yearsi just wonder why it is set as fr_FR by default. was deployed in production, before we ever knew.
-
Sam over 9 yearsafter setting the language to
en_GB
oren_US
usinglc-messages
you should restart mysql server. -
Dr Deo over 9 yearswho uses french anyway as default production language
-
RiggsFolly over 9 years@DrDeo Well like I said in the asnwer, the nice people at AlterWay are French, so I assume while testing a release they find it useful to see messages in their own language!
-
dg99 over 9 yearsThis answer (formatting aside) is a duplicate of the already-accepted answer. Did you have something additional to add?
-
tormuto almost 9 yearsAnd if you're an American English fan, use en_US instead of en_GB :)