注册用户 登录 论坛
您的位置：BugFree > 论坛 > 技术支持 > BugFree精华贴 > Windows2003+BugFree1.1+GREENAMP050123，install.php无法保存设置
2007-06-04 09:34:55 Windows2003+BugFree1.1+GREENAMP050123，install.php无法保存设置
#1
starsail
访问次数 : 71
注册日期 : 06-07-15 23:46
上次访问 : 09-10-29 21:05
 如题，安装完后进入install.php输入各项配置，保存，然后报错：
BugFree数据库: Client does not support authentication protocol requested by server; consider upgrading MySQL client
用户验证表:
管理员创建失败Client does not support authentication protocol requested by server; consider upgrading MySQL client

直接用MYSQL是可以进入并创建库、表的。

另外进入GreenAMP的PhpMyAdmin也不行，弹出Windows用户验证框，验证不了。默认应该是用户名root，密码为空吧？但就是不让进去。
回帖
2007-06-04 10:24:04
#2
starsail
访问次数 : 71
注册日期 : 06-07-15 23:46
上次访问 : 09-10-29 21:05
 搞定！

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

首先进入MYSQL： mysql -uUsername -pPassword mysql
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

或者：

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';mysql> FLUSH PRIVILEGES;
回帖