Instant Rails mySQL Error

rubyonrails-talk
1

I have tried everything in my power to get this program up and running and it is not working for me. I have installed RoR on my Windows XP machine. I have Instant Rails and Ruby on Rails and I am using Instant Rails to connect the mySQL database to Ruby on Rails. It is not working.

Everything works fine except when I create a scaffold it gives me an error in mySQL. The error reads,

"> ruby script/generate scaffold Product Admin exists app/controllers/ exists app/helpers/ exists app/views/admin exists app/views/layout exists test/functional/ dependency model exists app/models/ exists test/unit/ exists test/fixtures/ identical app/models/product.rb identical test/unit/products.ywl identical test/fixtures/product.yml #28000Access denied for user 'root'@'localhost' (using password: NO)".

I have done this several time and continue to get the same error. Is there anyone that can chat with me on an instant messenger or live chat to help me with my problem, if possible.

2

It seems that you have not specified mysql username and password correctly edit your config/database.yml , set proper values for mysql connection .

-Ajay Maurya

3

My config/database.yml files shows,

# MySQL (default setup). Versions 4.1 and 5.0 are recommended.

4

You didn't specify root's password, if this is ok try to login to mysql console without password, does this allow you ?

5

Try adding the port for mysql:

development:   adapter: mysql   database: depot_development   username: root   password:   host: localhost   port: 3306

That work? This fixed another windows users issue that was very similar.

Mr. Watson wrote:

6

hm strange ..

Maybe you installed mysql separately from InstantRails ?

With InstantRails, you dont need install anything, everything is bundled: ruby, ror, some gems, mysql, apache, phpmyadmin for mysql.. And mysql configured (default by Instant rails) to be set to root without password. thats my way on windows.

Then u start instantrails, does mysql running normally ? (3306 port) ?

Also try to run apache and browse http://localhost/phpmyadmin and get some access..

<offtop> donate to Yulia http://www.yulia-site.org </offtop>