我已经为此纠结了一段时间。

我已经在我的雪豹机器上安装了Rails 3, gem, mysql。一切都很顺利,直到我创建了我的第一个项目并试图运行

rails server

在运行这个我得到:

jontybrook$ rails server
/Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2/mysql2.bundle: dlopen(/Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2/mysql2.bundle, 9): Library not loaded: libmysqlclient.16.dylib (LoadError)
  Referenced from: /Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2/mysql2.bundle
  Reason: image not found - /Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2/mysql2.bundle
    from /Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2.rb:7
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:64:in `require'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:64:in `require'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:62:in `each'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:62:in `require'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:51:in `each'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler/runtime.rb:51:in `require'
    from /Library/Ruby/Gems/1.8/gems/bundler-1.0.7/lib/bundler.rb:112:in `require'
    from /Users/jontybrook/Dropbox/CODING/simple_cms/config/application.rb:7
    from /Library/Ruby/Gems/1.8/gems/railties-3.0.3/lib/rails/commands.rb:28:in `require'
    from /Library/Ruby/Gems/1.8/gems/railties-3.0.3/lib/rails/commands.rb:28
    from /Library/Ruby/Gems/1.8/gems/railties-3.0.3/lib/rails/commands.rb:27:in `tap'
    from /Library/Ruby/Gems/1.8/gems/railties-3.0.3/lib/rails/commands.rb:27
    from script/rails:6:in `require'
    from script/rails:6
jontybrook$ 

据我所知,问题是与mysql2宝石。MySQL似乎运行良好,我的Gemfile引用mysql2,我的数据库。Yml文件似乎也可以。

错误中提到

Reason: image not found - /Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2/mysql2.bundle

然而,

jontybrook$ cd /Library/Ruby/Gems/1.8/gems/mysql2-0.2.6/lib/mysql2
jontybrook$ ls
client.rb   em.rb       error.rb      mysql2.bundle result.rb

MySQL2。捆绑在那里!?

如果我使用旧的mysql gem, WEBrick启动正常。但这并不理想,不是吗?

谷歌能给我的我都试过了!任何帮助都非常感激。


当前回答

这通常发生在你升级mysql的时候。安装的mysql2 gem是建立在旧的mysql库上的,不能与新的库一起工作。只需要重新安装。

用gem卸载mysql2。然后用gem install mysql2安装它

其他回答

在OSX El Capitan更新时,你这样做:

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

它抛出一个错误

ln: /usr/lib/libmysqlclient.18.dylib: Operation not permitted

因此,为了避免这种情况,您可以首先定位libmysqlclient.18。使用命令Dylib

User$ locate libmysqlclient.18.dylib

在我的例子中,它返回/usr/local/mysql-5.5.24-osx10.5-x86_64/lib/libmysqlclient.18.dylib

因此,我们将创建usr/local/lib/的符号链接,如下所示:

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/lib/libmysqlclient.18.dylib

详情:https://forums.developer.apple.com/thread/7935

我是这样做的:

我运行下面的命令 18.执行install_name_tool -change libmysqlclient. sh命令。dylib /usr/local/mysql/lib/libmysqlclient.18。dylib ~ / .rvm /珠宝/ ruby-1.9.2-p180 /珠宝/ mysql2-0.2.7 / lib / mysql2 / mysql2.bundle

我的环境: $ rails -v Rails 3.0.6

$ mysql mysql version 14.14 Distrib 5.5.11,用于osx10.6 (i386),使用readline 5.1

$ ruby -v Ruby 1.9.2p180 (2011-02-18 revision 30909) [x86_64-darwin10.7.0]

希望这能帮助到一些人。

对我来说,我必须手动卸载mysql

brew uninstall mysql
rm -rf /usr/local/var/mysql
brew install mysql

刚刚遇到了这个问题。我所要做的就是卸载mysql2 gem并重新安装它。希望这对其他人也有用

我的luvlss命令版本:

Mac OSX 10.10.5

MySQL 5.6.27

乘客5.0.21

Sudo ln -s /usr/local/mysql-5.6.27-osx10.8-x86_64/lib/libmysqlclient.18。dylib /usr/lib/libmysqlclient.18.dylib

如果你正在尝试很多不同的链接,就像我做的那样,做一些清理:

取消链接/usr/lib/libmysqlclient.18.dylib