Box : Fedora Core 3
MYSQL : 4.1.10
PHP : 4.3.10-3.2
Webmin : 1.180
i have a strange error since upgraded MYSQL from 3.23 to mysql4
PHP scipts are works perfectly with MYSQL server
but once i change the user's password, the php scripts unable connect to mysql server, error message :
Code:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
another users who keep the original password are works as well ...
i'm confused
here is the password encrypted view from Webmin MYSQL module
user host Encrypted password
-------------------------------------------------------------
tester localhost 2e134e777c2d75cb
tester2 localhost *09A28A7B6574B1E02F963C904F77CFA37821640E
user
tester (using original password b4 upgrade) is connected to mysql server perfectly
but user
tester2 (using new password after upgrade) seems the encrypted a strange password
Quote:
[root@vhsv ~]# rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-9
php-mysql-4.3.9-3
r[root@vhsv ~]# rpm -qa | grep MySQL
perl-DBD-MySQL-2.9003-5
MySQL-client-4.1.10a-0
MySQL-shared-4.1.10a-0
MySQL-server-4.1.10a-0
MySQL-python-0.9.2-4
MySQL-shared-compat-4.1.10a-0
|
anyone please tell me what was going on ??