rails 配置 mysql

这段时间一直在尝试着学习ROR.今天试着配置了下ralis配置mysql数据库.不玩是不知道啊!!!真正动起手来问题是一堆接一堆啊!中途都有点自暴自弃想give up.但挺挺还是过来了...
这边ROR的环境搭建就不谈了.网上Google一下一大把.这里我所用的ruby是1.9.2p180, ralis是3.0.9 .
rails 配置 mysql (最好事mysql server5.0版本)
1.安装mysql
2.在mysql安装目录的bin目录下,找到libmysql.dll,将该文件copy到ruby安装目录的bin目录中.
3.gem install mysql (安装rails 的mysql 驱动包)

[img]http://dl.iteye.com/upload/attachment/510429/1bae0e80-ee7b-3a51-9292-7171c2c3f3cd.jpg[/img]

[color=red]4.把下载的ruby文件中的mysql.so文件(我的是在里 C:\Ruby192\lib\ruby\gems\1.9.1\gems\mysql-2.7.3-x86-mswin32\ext)复制到(C:\Ruby192\lib\ruby\site_ruby\1.9.1\i386-msvcrt)[/color]
4. rails new depot
5.修改depot工程config==========>database.yml:
development:
adapter: mysql
database: login
host: localhost
username: root
password: 1234
test:
adapter: mysql
database: login_test
host: localhost
username: root
password: 1234

production:
adapter: mysql
database: login_production
host: localhost
username: root
password: 1234
[color=red]6.修改工程下面的Gemfile ========在Gemfile中添加gem 'mysql'[/color]
7.Eg: rails generate scaffold Product title:string description:text image_url:string:string price:decimal publication:date
8.rake db:migrate

[img]http://dl.iteye.com/upload/attachment/510431/1b1f7ae2-270d-3292-8d2c-26f84ab13875.jpg[/img]

9.打开数据就可看到执行命令所建的表了.当然数据库必须首先建好.