‘`require'：不正确的MySQL客户端库版本

Question

当我运行rails服务器时，它显示如下错误消息：

`require': Incorrect MySQL client library version! This gem was compiled for 6.0.0 but the client library is 5.1.42. (RuntimeError)
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/mysql-2.9.1-x86-mingw32/lib/mysql.rb:4:in `<top (required)>'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `require'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `block (2 levels) in require'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `each'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `block in require'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `each'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `require'
        from C:/Rails/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/bundler-1.3.5/lib/bundler.rb:132:in `require'

我安装了MySQL5.1数据库。

在我的gem文件中，我写道：

gem 'mysql'

然后运行bundle install

是什么导致了这个问题？

Answer 1

试试这个

添加你的Gemfile

 gem 'mysql2'

然后执行bundle install，并在命令行中运行此命令来安装这些包。

   sudo apt-get install mysql-client libmysqlclient-dev

在windows上

将libmysql.dll从mysql安装文件夹复制到系统上的Ruby bin目录中。

Answer 2

我认为您应该尝试包含mysql2 gem，只需在您的gem文件中添加：

gem 'mysql2'