phpMyAdmin错误#1649未知语言环境 [英] phpMyAdmin Error #1649 unknown locale

问题描述

我正在检查本地主机(WAMP 3.0.6)上的phpMyAdmin中的某些内容，突然我被以下错误锁定:

I was checking some thing in phpMyAdmin on localhost (WAMP 3.0.6), when suddenly I got locked out with following error:

Error

SQL query: Edit

SET lc_messages = 'en_US';

MySQL said:
#1649 - Unknown locale: 'en_US'

我只是在四处张望，我相信当我在常规设置" 下的服务器连接排序规则" 下拉菜单中意外选择另一个值时，会发生错误除了默认值以外的其他内容.

I was merely just looking around, and I believe the error occurred when I accidentally selected another value in "Server connection collation" dropdown under "General Settings", to something else than it's default.

语言在my.ini中设置为lc_messages = 'en_US';

我尝试重新安装WAMP，但是没有成功.每当我尝试登录phpMyAdmin时，错误仍然显示.所以我不确定实际的问题是什么.

I've tried re-installing WAMP, but without success. The error still shows up every time I try to login to phpMyAdmin. So I'm not sure what the actual problem is.

谢谢.

推荐答案

尝试清除phpMyAdmin cookie(通常以'pma'开头).实际上，您只需要清除'pma_lang'cookie.

Try clearing your phpMyAdmin cookies (which usually start with 'pma'). Actually, you should only need to clear the 'pma_lang' cookie.

我不确定问题的根本原因是什么(也许您的MySQL没有安装en_US语言包，或者它是旧的MySQL版本或其他东西).在my.ini中定义了"en_US"有点奇怪，但是在被phpMyAdmin调用时却给出了错误.

I'm not sure what the root cause of your problem is (maybe your MySQL doesn't have the en_US language pack installed, or maybe it's an old MySQL version or something). It's a bit strange that 'en_US' is defined in my.ini but gives an error when called by phpMyAdmin.

但是，通过更改语言下拉列表，phpMyAdmin现在认为您想显式强制使用特定语言(在这种情况下为en_US，但可以是任何语言环境)，因此，当它连接到MySQL时，它会尝试的第一件事要做的是强制区域设置，这会导致错误.通过清除"pma_lang" Cookie，您将重置phpMyAdmin中的语言首选项，它应返回到使用系统默认值，并且在连接到MySQL时不强制执行任何操作，这将清除错误消息.

However, by changing the language dropdown, phpMyAdmin now thinks you want to explicitly force a specific language (en_US, in this case, but it could be any locale), so when it connects to MySQL one of the first things it tries to do is force the locale, which causes the error. By clearing the 'pma_lang' cookie, you'll reset the language preference within phpMyAdmin and it should go back to using the system default and not force anything when connecting to MySQL, which will clear up the error message.

如果您对此感兴趣，那么为什么会首先发生此问题的其他问题，应该直接直接与WAMP的人员联系，因为它们的工具包似乎有点故障，但这至少可以使phpMyAdmin重新工作.

Further questions of why this occurred in the first place, if that interests you, should probably be directed to the WAMP folks directly since it kind of seems like a glitch with their kit, but at least this gets your phpMyAdmin working again.

这篇关于phpMyAdmin错误#1649未知语言环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！