WAMP/MySQL errors not in correct language
PhpMysqlPhpmyadminWampserverPhp Problem Overview
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.
Php Solutions
Solution 1 - Php
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 - Php
Change the following settings in my.ini file
lc-messages=en_US
To permanently change the language preferences
Solution 3 - Php
$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';