安装mysql2 gem错误

Question

我通过macport安装了ruby和ruby，但是宝石列表不包括mysql2。那么，如何将mysql2 gem安装在我的gem列表中，该列表位于"/opt/local/bin/gem“中

另外，什么是mysql2宝石？我有mysql，只想使用mysql，不太确定它对mysql2意味着什么。当我试图在应用程序上启动webrick时，它给了我一个mysql2错误。

更新:我运行sudo安装了mysql2并获得了以下内容：

构建本机扩展。这需要一段时间..。成功安装mysql2-0.2.7 1 gem为mysql2-0.2.7安装ri文档。 为类客户端封装类/模块“mMysql2” 附件类/模块'mMysql2‘的类结果不知道安装RDoc文档的mysql2-0.2.7. 为类客户端封装类/模块“mMysql2” 封装类/模块“mMysql2”以表示未知的类结果

假设安装了mysql2，即使文档没有安装，我尝试在我的应用程序中启动webrick时也会出现以下错误。

rails服务器：

/opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2/mysql2.bundle: dlopen(/opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2/mysql2.bundle，9)：未加载的库: libmysqlclient.18.dylib (LoadError) 引用来源: /opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2/mysql2.bundle原因:图像未找到- /opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2/mysql2.bundle从/opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2.rb:8到/opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:64:in require' from /opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:64:in要求“/opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:62:in each' from /opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:62:in require”来自/opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler来自/opt/local/lib/ruby/gems/1.8/gems/铁路的/opt/local/lib/ruby/gems/1.8/gems/railties-3.0.7/lib/rails/commands.rb:28 /runtime.rb:51:in each' from /opt/local/lib/ruby/gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:51:in要求“从/runtime.rb:51:in require' from /Users/summer/Sites/simple_cms/config/application.rb:7 from /opt/local/lib/ruby/gems/1.8/gems/railties-3.0.7/lib/rails/commands.rb:28:in require”-3.0.7/lib/rails/commands.rb:27:in tap' from /opt/local/lib/ruby/gems/1.8/gems/railties-3.0.7/lib/rails/commands.rb:27 from script/rails:6:inrequire‘from script/rails:6

Answer 1

据我所知，这两个宝石(mysql和mysql2)之间的一个不同之处是，mysql2在UTF-8中工作得更好。关于这件事，是一篇文章。

要安装mysql2 gem，只需运行：

gem install 'mysql2'

Answer 2

为了执行对可用的远程宝石的搜索，运行命令gem search mysql2 -r (请注意末尾的-r )

*远程宝石*

activerecord-mysql2legacydb-适配器(0.2.0) activerecord- mysql2 2空间适配器(0.3.2) em_mysql2_connection_pool (0.0.5) ghazel-mysql2 2 (0.2.6.3) mysql2 (0.2.7，0.2.6x86-mswin32-60) mysql2_bigint (0.2.6.1) mysql2_model (0.1.2) mysql2mysql (0.0.2) mysql2psql (0.1.0) mysql2xxxx (0.0.4)

从宝石列表中，您应该选择mysql2并运行sudo安装mysql2。