Question

rails无法连接mysql数据库，搞不定，求救

C:\Users\Administrator\rails4>rails server
C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/mysql2.
rb:2:in `require': Incorrect MySQL client library version! This gem was compiled
for 6.0.0 but the client library is 5.5.28. (RuntimeError)
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2/mysql2.rb:2:in `<top (required)>'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2.rb:9:in `require'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2.rb:9:in `<top (required)>'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:72:in `require'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:72:in `block (2 levels) in require'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:70:in `each'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:70:in `block in require'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:59:in `each'
from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runti
me.rb:59:in `require'

from C:/Ruby193/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler.rb:13
2:in `require'
from C:/Users/Administrator/rails4/config/application.rb:7:in `<top (req
uired)>'

Answer 1

你需要需要安装mysql2， 在命令行中输入gem install mysql2，等待安装完成后，进入你创建的项目路径，修改config/database.yml:

adapter: mysql2
encoding: utf8
database: 数据库名
username: 账号(root)
password: 密码
pool: 5
timeout: 5000
修改Gemfile：
将gem 'sqlite3' 改为 gem 'mysql2'