MySQL Unit Test Login Failure

Rails
1

I just recently started having issues running unit tests for my
application, but can’t figure out why. When I run rake test:units, I
get “Access denied for user ‘root@localhost’ using password: NO”.

My database.yml file is configured to use the ODBC login, but it’s not
being passed to my unit tests. Any ideas?

development:
adapter: mysql
encoding: utf8
database: db_development
username: ODBC
password:
socket: /tmp/mysql.sock

test:
adapter: mysql
encoding: utf8
database: db_test
username: ODBC
password:
socket: /tmp/mysql.sock

2

U have odbc as the user for test db. But u have root as user in mysql.
Either change odbc to root or create odbc user in mysqladmin.

Http://www.rubyplus.org
Free Ruby & Rails screencasts

On Apr 5, 2008, at 2:19 PM, Becca G. <rails-mailing-list@andreas-

3

Bcp wrote:

U have odbc as the user for test db. But u have root as user in mysql.
Either change odbc to root or create odbc user in mysqladmin.

I have both the root and ODBC users set up in mysql. I thought that the
database.yml file would tell the tests to use the ODBC user instead of
the root user. Is there some other location where the test is getting
the user?

4

After digging around the environment was being set in another spot, so
as soon as I commented that out, everything worked great.