澳门新葡亰平台官网Mysql 4.1 Windows 下升级问题

使用PHPMYADMIN时报错: Client does not support authentication protocol
requested by server; consider upgrading MySQL client 官方的说法是 MySQL
4.1 and up uses an authentication protocol based on a password hashing
algorithm that is incompatible with that used by older clients. …..
如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client
是4.1或者更高版本.(WINDOWS下有问题你就直接跳到下面看解决方法了,因为MYSQL
在WINDOWS是client和server一起装上了的) 请使用以下两种方法之一 其一:
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;

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图