语言不正确的 WAMP/MySQL 错误

我重新安装了 WAMP 多次，搜索了几百页，它并没有解决这个问题:

enter image description here

我查看了 phpmyadmin 配置文件，设置:

$cfg['Lang'] = 'en-utf-8';

多次卸载(如上所述) ，似乎没有什么运气。任何帮助将不胜感激。

49018 次浏览
小开

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

小开
最佳答案

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

小开

Change the following settings in my.ini file

lc-messages=en_US

To permanently change the language preferences


提交答案