rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib

by

The solution is pretty easy; Add the library path in your ~/.bash_profile or ~/.profile file:

MYSQL=/usr/local/mysql/bin
export PATH=$PATH:$MYSQL
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

If it is still not working (this work for me):

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

There are many blogs with install_name_tool, which won’t work for me because I’m on OSX Lion:

sudo install_name_tool -change libmysqlclient.18.dylib /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/bin/indexer
sudo install_name_tool -change libmysqlclient.18.dylib /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/bin/search

More Related Contents:

  1. Error installing mysql2: Failed to build gem native extension
  2. Rails, MySQL and Snow Leopard
  3. MySQL Install: ERROR: Failed to build gem native extension
  4. How to delete duplicate records in mysql database?
  5. libmysqlclient15-dev on macs?
  6. Correct MySQL configuration for Ruby on Rails Database.yml file
  7. What the difference between mysql and mysql2 gem
  8. Rails select random record
  9. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  10. brew install mysql on macOS
  11. ‘sudo gem install’ or ‘gem install’ and gem locations
  12. Setting the MySQL root user password on OS X
  13. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  14. MySQL user DB does not have password columns – Installing MySQL on OSX
  15. Rails 3 ActiveRecord: Order by count on association
  16. How do you uninstall MySQL from Mac OS X?
  17. Restoring deleted ‘root’ user and password for MySQL
  18. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  19. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  20. how to solve “ruby installation is missing psych” error?
  21. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  22. How do I use RVM and create globally available gems?
  23. Ruby gem mysql2 install failing [duplicate]
  24. Connect to Docker MySQL container from localhost?
  25. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  26. PID error on mysql.server start?
  27. Getting a “bad interpreter” error when using brew
  28. How to start MySQL server from command line on Mac OS Lion?
  29. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  30. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)

Leave a Comment