[Instantrails-users] Connection problems to DB using password

[David Morton]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Al Olese wrote:
> Hello, I am using InstantRails 1.3a and I am having trouble. If I try to 
> enable passwords in database.yml for the mysql account, I get a "Before 
> updating scaffolding from new db schema, try creating a table for your 
> model" message if I try to do a simple script/generate scaffold command. I 
> get the same message if I use a bogus password, but if I disable the 
> password (and do the same in mysql of course) things work as normal again... 
> any ideas?
> 
> I can use the standard mysql client to access the database when the password 
> is set so there is nothing wrong with the privileges.

Ok, now that I have a windows box running again.... :)

How did you go about changing the password?  That error message about
"mysql.user table is not updated to new password format" is the problem. I think
you said you had mysql 4? what steps did you take to change the password in mysql?



- --
David Morton
Maia Mailguard                        - http://www.maiamailguard.com
Morton Software Design and Consulting - http://www.dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEqD0DUy30ODPkzl0RAnhKAKCRMIKkxE0BTDcbfW2BO3Xb4MycSACfbvcT
Nu1T3USsgXMBMBwuXX8TJVg=
=vsXh
-----END PGP SIGNATURE-----