修改phpMyAdmin密码后无法登陆的解决方法

　　#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client,请问这是什么意思?怎么解决?

　　mysql #1251是什么意思?

　　PHP（PHP培训 php教程 ）myadmin也不能登陆,欢迎使用 phpMyAdmin 2.9.0

　　Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.

　　错误

　　MySQL 返回：

　　#1045 - Access denied for user: 'root@localhost' (Using password: NO)

　　以上应该是修改密码不当引起的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;　

　　SET PASSWORD FOR 'root@localhost' = OLD_PASSWORD('newpwd');

　　或者同另外一句,更改完成后执行FLUSH PRIVILEGES;或者重启mysql

　　NET STOP MYSQL;

　　NET START MYSQL;

声明： 此文观点不代表本站立场；转载须要保留原文链接；版权疑问请联系我们。