rhizmoe: my mysql server is password protected (ie root does have a password). If rails was not able to login, it would not have been able to create the database to start with. This doesn't make sense.
rhizmoe: ok. i found out what theproblem is. I only provided the root password for the development database and not for production and test. This is where the login failure came from.. Problem Solved. Thanks.