Rails2.0以前,Rails是把MySQL数据库作为默认的数据库配置的,也就是不用配置MySQL的数据库就可以直接使用了。但由于现在MySQL已经属于Sun公司了(虽然它还是免费的),Rails2.0以后就把sqlite3作为默认的数据库来使用了。
因此,现在在Rails中使用MySQL是要做一点配置的,也就是修改database.yml文件。
# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: mysql
encoding: utf8
database: ruby_dev
# pool: 5
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
# host: localhost
# 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: ruby_test
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
production:
adapter: mysql
database: ruby_prod
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
[b]注意:key: value,中间有个空格[/b]
还可以在创建的时候配置mysql rails 项目名 -d mysql
因此,现在在Rails中使用MySQL是要做一点配置的,也就是修改database.yml文件。
# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: mysql
encoding: utf8
database: ruby_dev
# pool: 5
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
# host: localhost
# 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: ruby_test
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
production:
adapter: mysql
database: ruby_prod
timeout: 5000
username: root
password: 1234
host: 127.0.0.1
[b]注意:key: value,中间有个空格[/b]
还可以在创建的时候配置mysql rails 项目名 -d mysql