How to Fix the \'Library not loaded: libmysqlclient.18.dylib\' Error When Using Rails and MySQL on macOS?

'rails MySQL on OSX: Library not loaded: libmysqlclient.18.dylib' Issue Encountered

When transitioning from SQLite to MySQL in a Ruby on Rails project on macOS, you may encounter an error message due to the inability of Rails to locate the required MySQL library.

Error Details

Upon attempting to create the Rails database with MySQL, you might encounter the following error:

rake aborted!
dlopen(/Users/username/.rvm/gems/ruby-1.9.3-p194@rails3tutorial2ndEd/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle, 9): Library not loaded: libmysqlclient.18.dylib
...

This error indicates that Rails cannot find the required libmysqlclient.18.dylib library.

Solution

To resolve this issue, you need to specify the path to the MySQL library. Update your .bash_profile or .profile file with the following lines:

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

If the issue persists, additionally run:

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

The above is the detailed content of How to Fix the \'Library not loaded: libmysqlclient.18.dylib\' Error When Using Rails and MySQL on macOS?. For more information, please follow other related articles on the PHP Chinese website!