76

I've re-installed WAMP multiple times, searched literally hundreds of pages, and its not fixed this issue:

enter image description here

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.

potashin
  • 44,205
  • 11
  • 83
  • 107
Dobby
  • 856
  • 1
  • 6
  • 8
  • 1
    What does that error actually translate as? – MackieeE May 22 '14 at 09:36
  • 2
    @MackieeE: "no database selected" – Mat May 22 '14 at 09:36
  • I have no clue. On my SAMP server i am (deliberately) making mysql errors, it's looking like: (error #1045) Accès refusé pour l'utilisateur: 'Dobby'@'@localhost' (mot de passe: OUI). So the default language (google) is french, odd. I'm interested in changing it though, since i have no clue how to read french. – Dobby May 22 '14 at 09:38
  • @user3664313 Try the answers from [here](http://stackoverflow.com/q/8542961) – HamZa May 22 '14 at 09:39
  • Change the installer version – Qarib Haider May 22 '14 at 09:40
  • Still the same thing guys (thanks so far though). PC Language is English, everything else is too. @SyedQarib i'm using the one from the wampserver website. Is there any other versions? – Dobby May 22 '14 at 09:45

3 Answers3

175

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

Community
  • 1
  • 1
RiggsFolly
  • 93,638
  • 21
  • 103
  • 149
  • Searching for the command may be easier as it is not on the first few lines. Thanks for the solution. – Dave Oct 13 '14 at 14:51
  • 27
    I set mine to: lc-messages=morse_CODE and now my errors are coming out like this: -.-- --- ..- / .... .- ...- . / .- -. / . .-. .-. --- .-. / .. -. / -.-- --- ..- .-. / -- -.-- ... --.- .-.. / ... -.-- -. - .- -..- – James Wilson Oct 16 '14 at 12:26
  • 6
    @JamesWilson Whatever floats your boat – RiggsFolly Oct 16 '14 at 22:11
  • i just wonder why it is set as fr_FR by default. was deployed in production, before we ever knew. – Ryan Nov 18 '14 at 07:38
  • 2
    after setting the language to `en_GB` or `en_US` using `lc-messages` you should restart mysql server. – Sam Nov 26 '14 at 09:26
  • 5
    who uses french anyway as default production language – Dr Deo Dec 15 '14 at 06:18
  • 5
    @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! – RiggsFolly Dec 15 '14 at 09:06
  • And if you're an American English fan, use en_US instead of en_GB :) – tormuto Sep 05 '15 at 08:33
4

Change the following settings in my.ini file

lc-messages=en_US

To permanently change the language preferences

bummi
  • 27,123
  • 14
  • 62
  • 101
Rooha Ali
  • 129
  • 1
  • 7
  • 6
    This answer (formatting aside) is a duplicate of the already-accepted answer. Did you have something additional to add? – dg99 Feb 26 '15 at 18:24
2

$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';

Eugen Rieck
  • 64,175
  • 10
  • 70
  • 92
  • 1
    How do i do the `--lc_messages=en_US` in windows? :S – Dobby May 22 '14 at 09:44
  • IIRC you just put it into `my.ini` or `my.cnf`, whatever you have, in the `[mysqld]` section, like `lc_messages = en_US`, ofcourse you need to restart the server. Haven't used Windows in a long time, though. – Eugen Rieck May 22 '14 at 09:48