WampServer

I can't seem to figure out how to change the language from French to English for Sql errors.

I have modified the lc-messages in my.ini to lc-messages=en_US but still get sql errors in french.

On the home page of phpmyadmin English is the language chosen and all the screens show up in english.

But when I go into and SQL: query and force a syntax error (for example) I get the error in French not English.

Here is an example:

Error

SQL query:

dafimfad
a
f
ad
fa

MySQL said: Documentation
#1064 - Erreur de syntaxe près de 'dafimfad
a
f
ad
fa' Ã la ligne 1

Here is a dump of a portion of the my.ini:

[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp2-5/bin/mysql/mysql5.6.17
log-error=c:/wamp2-5/logs/mysql.log
datadir=c:/wamp2-5/bin/mysql/mysql5.6.17/data
#datadir=c:/wamp-2-2/bin/mysql/mysql5.0.51b/data

lc-messages-dir=c:/wamp2-5/bin/mysql/mysql5.6.17/share

# Change your locale here !
lc-messages=en_US
# Avoid warning
explicit_defaults_for_timestamp = TRUE

The lc-messages-dir is correct.

Here is a snippet from the home page of phpmyadmin that shows mysql5.16.17 is the version of msql running:

Database server

Server: mysql wampserver (127.0.0.1 via TCP/IP)
Server type: MySQL
Server version: 5.6.17 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

Apache/2.4.9 (Win32) PHP/5.5.12
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id:


I don't have any other versions of mysql loaded on the laptop...

Any help would be greatly appreciated.

Warren

Never mind. I thought I had restarted services after modifying the my.ini but I hadn't. Once mysql service restarted all is OK.

Thanks,

Warren