WampServer

Hi Everybody,

(Details at bottom)

When I use the MySQL Console, any errors will be flagged with a French language comment. I could change the language selection with the following:

mysql> SET lc_messages = 'en_US';

However, I do need to enter this with each instance of the MySQL Console use. This is a very workable but short-term "fix".

I would like to find the default key and change THAT to an English language comment... so that it is permanent. I would have thought I would find the right attribute in the "my.ini" but it didn't exist there.

Searched through the entire wamp/bin files looking for that expression "SET lc_messages"...but failed.

Can someone help me to change the error comments to English permanently?

Many thanks,

Paul

Details:
O/S Windows 7 Home Premium 64-b SP1
Windows Defender enabled
Antivirus Avast!
Browser FireFox 36.0.4
Version WampServer 2.5
Apache Version 2.4.9
PHP Version 5.5.12
MySQL Version 5.6.17
WampServer icon Green



Edited 1 time(s). Last edit at 03/27/2015 01:30PM by jPaulB.

Hi Paul,

Yes its easy.

Edit my.ini using the wampmanager menus

wampmanager -> MySQL -> my.ini


Find this line

# Change your locale here !
lc-messages=fr_FR

And change it to

# Change your locale here !
lc-messages=en_GB

Or this if you prefer

# Change your locale here !
lc-messages=en_US

Oh and if you installed the 64bit WAMPServer also change the section heading from [wampmysqld] to [wampmysqld64] or MySQL wont spot the change.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 03/27/2015 01:54PM by RiggsFolly.