RoR uses SQLite out of the box, why install and use that when the project will use MySQL?
And i used Xampp because it was suggested, and it was a painless install with a nice control panel and security script.
database.yml (i have tried all kinds of different settings. User is correct, pw doesnt exist, host is localhost, and dbname, afaik, can be whatever i put there. I dont see anywhere in xampp to make one and it seems RoR creates it on the first launch....
# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: mysql
database: demo__development
username: lampp
password:
host: localhost
timeout: 5000
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
adapter: mysql
database: demo__development
username: lampp
password:
host: localhost
timeout: 5000
production:
adapter: mysql
database: demo__development
username: lampp
password:
host: localhost
timeout: 5000