Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: 3rdRail/Ruby and Rails Consoles    [ Add a report in this area ]  
Report #:  52371   Status: Closed
MySQL won't migrate either
Project:  3rdRail Build #:  v20070909_1913
Version:    unspecifie Submitted By:   Clay Shannon
Report Type:  Basic functionality failure Date Reported:  9/21/2007 12:35:56 PM
Severity:    Commonly encountered problem Last Updated: 10/3/2007 3:21:25 PM
Platform:    All versions Internal Tracking #:  
Resolution: Test Case Error (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
After getting an err msg trying to migrate a simple InterBase table, I created a new Rails project and another simple database using MySQL.

However, that also caused an err msg:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
rake aborted!
Access denied for user 'root'@'localhost' (using password: NO)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steps to Reproduce:
No steps given by submitter.

Notes by QA engineer:

This is most likely caused by note having database.yml set correctly.

In order for the Migration to work, you must have the correct password set in database.yml for the environment in use.


Since I have specified a password for my MySQL server, if I do the following:

> rails default
> cd default
default>rake db:migrate

I get the same error:

(in C:/RedDiamondTests/default)
rake aborted!
Access denied for user 'root'@'localhost' (using password: NO)


Solution:

Open config/database.yml

Edit the database configuration for the development environment:

development:
  adapter: mysql
  database: default_development
  username: root
  password:  <-------   enter the root password here .......
  host: localhost


Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01