Hello. Most probably the reason is in old_passwords in your configuration file. You can check this with the following statement: show variables like 'old_passwords';
Gary Huntress wrote: > I have a new installation of MySQL 5.0 (I did not port an old ver). I > am running a Ruby on Rails application that uses this db. I have grants > for [EMAIL PROTECTED], root@"localhost" and root@'192.168.0.63'. The > passwords for > these 3 grants are old style 16 byte hashes. There was one single grant > for root that had a 41 byte new style hash. I thought it was redundant > and deleted it. > > I can log in using the mysql client but my rails application can no > longer log in. I'm not 100% sure that the problem is because I removed > that grant but I'm fairly sure (no other configuration info has changed) > > My question is, why when I "GRANT all on *.* to root@'localhost' > identified by 'xxxxxxx'" do I get a 16 byte hash and not a 41 byte > hash? Since my theory is the lack of a grant with a 41 byte hash I'd > like to test that. How do I create 41 byte password hashes ? > > Thanks, > > Gary > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]