Is there a way i can convert the strings converted from old password to passwords one.So that it become compatible to the passwords one. -- Abhishek jain
Original Message: ----------------- From: Ryan Stille [EMAIL PROTECTED] Date: Wed, 18 Jan 2006 08:03:14 -0600 To: [EMAIL PROTECTED] Subject: RE: OLD_PASSWORD and PASSWORD whats these [EMAIL PROTECTED] wrote: > Dear Friends, > I had an application built using MySQL where i stored mine > customers passwords encrypted using password function of > mysql, now i changed mine servers and do find a new function > old_password and password. I believe that old_password is equivalent > to password. Actually i do not want to change mine application and > change old_password whereever i have password , also i want to have > all mine existing customers on the new server.So is there a > way where i could disable this feature of PASSWORD and > restore old function. > Pl. help me. > I shall be very grateful. > -- > Regards > Abhishek jain There is a start up option that is something like --use-old-passwords that makes MySQL 5.x behave like 4.x as far as passwords are concerned. Alternatively you can always set your passwords with OLD_PASSWORD() instead of PASSWORD() and you will have the old type of password. -Ryan -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
