LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   strange MYSQL password Encrypted (https://www.linuxquestions.org/questions/linux-newbie-8/strange-mysql-password-encrypted-307078/)

max_tcs 03-28-2005 01:28 PM

strange MYSQL password Encrypted
 
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 ??

Orkie 03-28-2005 01:59 PM

I have posted a solution in the other thread :).

Mara 03-28-2005 04:39 PM

Please do not post the same thread in more than one forum. Picking the most relevant forum and posting it once there makes it easier for other members to help you and keeps the discussion all in one place.

http://www.linuxquestions.org/rules.php

I'm losing this thread, please post all replies to the one in Linux-Software forum: http://www.linuxquestions.org/questi...hreadid=307077


All times are GMT -5. The time now is 01:35 PM.