Hmm could be due to this reported bug: http://dev.rubyonrails.org/ticket/10348
Try doing these steps first like the reporter suggests: rake mysql:build_databases rake test_mysql TEST=aaa_create_tables_test.rb Cheers, Chu Yeow On Dec 4, 1:23 am, "E. James O'Kelly" <[EMAIL PROTECTED]> wrote: > the second was > mysqladmin -uroot create activerecord_unittest2 > > On Dec 3, 9:18 am, "E. James O'Kelly" <[EMAIL PROTECTED]> > wrote: > > > I am having the same problem. > > > I created the rails user > > I created the two databases: > > mysqladmin -uroot create activerecord_unittest > > mysqladmin -uroot create activerecord_unittest > > I granted permissions: > > mysql -uroot > > GRANT ALL PRIVILEGES ON activerecord_unittest.* to > > 'rails'@'localhost'; > > GRANT ALL PRIVILEGES ON activerecord_unittest2.* to > > 'rails'@'localhost'; > > > I run the test: > > raketest_mysql > > > And I get the exact same error. > > > On Dec 1, 10:30 pm, chuyeow <[EMAIL PROTECTED]> wrote: > > > > Hmm Frederick is right, that's all I've had to do. If you read the > > > latest RUNNING_UNIT_TESTS (http://dev.rubyonrails.org/browser/trunk/ > > > activerecord/RUNNING_UNIT_TESTS) and the connection settings for > > > running tests on MySQL (http://dev.rubyonrails.org/browser/trunk/ > > > activerecord/test/connections/native_mysql/connection.rb), you pretty > > > much create the 'activerecord_unittest' and 'activerecord_unittest2' > > > databases and grant the 'rails' user all privileges and you're good to > > > go. > > > > What steps have you done? Perhaps that'd help us to find out what your > > > problem is. > > > > Cheers, > > > Chu Yeow > > > > On Nov 26, 7:32 pm, Hongli Lai <[EMAIL PROTECTED]> wrote: > > > > > On Nov 26, 11:45 am, Frederick Cheung <[EMAIL PROTECTED]> > > > > wrote: > > > > > > Unless this has changed recently I never had to do that. I just > > > > > created the activerecord_unittest and activerecord_unittest2 databases > > > > > and gave the rails user access to them and I was good to go > > > > > > Fred > > > > > That didn't work for me. I created the databases but got this > > > > error:http://pastebin.com/f1f641395 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
