您正在游览:修改phpmyadmin 密码及修改密码后不能登陆解决方法

当mysql管理员root口令为空时可以进入，改了密码后，再进就提示下面这些:
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client,请问这是什么意思?怎么解决?

 

mysql #1251是什么意思?

 

phpmyadmin也不能登陆,欢迎使用 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;