#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;