Ruby on Rails

On Jul 2, 2010, at 12:46 PM, Dave Digital wrote:

> Rob Biedenharn wrote:
>> In case the "hints" are too subtle, I suspect you took the example
>> and
>> fixed sqlite3 => mysql and set your database name. Since SQLite
>> doesn't need username/password, you didn't have those in the example.
>> Put them in and you're probably going to be all set.
>
> I'm not using SQLite, I have MySQL installed. I'm not getting
> permission
> or login errors so I don't see how that is relavant with an error like
> this
>
> Mysql::Error: query: not connected: CREATE TABLE `schema_migrations`
> (`version`
> varchar(255) NOT NULL) ENGINE=InnoDB

Well, I'm taking "not connected" to indicate something that's not too
different from a login error.

database.yml
------------------------------------------------------------------------

development:
adapter: mysql
database: music_library_development
pool: 5
timeout: 5000
host: localhost

In your database.yml, there are no login credentials. Assuming that
you can get connected (logged in) to your mysql with absolutely no
user or password, maybe this is right, but I doubt it.

If your root user doesn't have a password, try this:

development:
adapter: mysql
database: music_library_development
username: root
password:
pool: 5
timeout: 5000
host: localhost

(Note that there should be two spaces on the indented lines.)

If you have some other username/password, use those. In any case, you
should be able to connect with:
mysql -u root
mysql -u root -p
> then type the root user's password
mysql -u yourusername -p
> then type yourpassword

How does that work for you?

-Rob

Rob Biedenharn
Rob@AgileConsultingLLC.com http://AgileConsultingLLC.com/
rab@GaslightSoftware.com http://GaslightSoftware.com/

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.