LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-28-2005, 02:27 PM   #1
max_tcs
LQ Newbie
 
Registered: Aug 2003
Posts: 27

Rep: Reputation: 15
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 ??
 
Old 03-28-2005, 02:46 PM   #2
Orkie
Member
 
Registered: Mar 2005
Distribution: Breezy Badger
Posts: 248

Rep: Reputation: 30
MySQL 4.1 changed the password format from previous versions. All PHP scripts need to use the mysqli functions/classes in order to use the new style password users.
If you change the password through the 'mysql' database, then you can execute this query to change a password back to the old format, thus making it compatible with your old scripts:

UPDATE user SET Password = old_password('[password to change it to]') WHERE User = '[user to update password for]';

Last edited by Orkie; 03-28-2005 at 02:48 PM.
 
Old 03-30-2005, 04:45 AM   #3
max_tcs
LQ Newbie
 
Registered: Aug 2003
Posts: 27

Original Poster
Rep: Reputation: 15
thankx ~!
it works
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] command to create encrypted password student04 Linux - Security 8 09-15-2013 09:44 PM
root password not encrypted meskensj Linux - Newbie 3 10-19-2005 05:56 AM
strange MYSQL password Encrypted max_tcs Linux - Newbie 2 03-28-2005 05:39 PM
encrypted password 64 characters? uribo Programming 1 04-22-2003 08:51 AM
Making An Md5 Encrypted Password Manually [BHBS]=TK Linux - Security 2 04-23-2002 05:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:15 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration