Client does not support authentication protocol requested by server
因为php3的密码在数据库里面是md5保存的,php5的密码改成sha1方式了,而你的程序用的libmysql.dll是老版本的,所以无法登录,解决的方法是: 1: update mysql.user set password=old_password('123456') where host='%' and user='user'; flush privileges; 2: set password for user@'%' = old_password('123456'); 3: mysql 4.1:在my.ini的[mysqld]段加上 old_password=1; mysql5: 在my.ini的[mysqld]段加上 set-variable=old_passwords;
UPDATE mysql.user SET Password = PASSWORD('234') WHERE Host = '%' AND User = 'locuser';
已解决,非常感谢大家. netwan(网络菜鸟) ( ) 信誉:92 Blog 厉害!!!! 方法很好!
1:
update mysql.user set password=old_password('123456') where host='%' and user='user';
flush privileges;
2:
set password for user@'%' = old_password('123456');
3:
mysql 4.1:在my.ini的[mysqld]段加上 old_password=1;
mysql5: 在my.ini的[mysqld]段加上 set-variable=old_passwords;
netwan(网络菜鸟) ( ) 信誉:92 Blog 厉害!!!!
方法很好!