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 'xxx' 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]