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
[email protected] http://AgileConsultingLLC.com/
[email protected] 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 [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-talk?hl=en.
