Python mysqldb: Library not loaded: libmysqlclient.18.dylib

by

I solved the problem by creating a symbolic link to the library. I.e.

The actual library resides in

/usr/local/mysql/lib

And then I created a symbolic link in 

/usr/lib

Using the command:

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

so that I have the following mapping:

ls -l libmysqlclient.18.dylib 
lrwxr-xr-x  1 root  wheel  44 16 Jul 14:01 libmysqlclient.18.dylib -> /usr/local/mysql/lib/libmysqlclient.18.dylib

That was it. After that everything worked fine.

EDIT:

Notice, that since MacOS El Capitan the System Integrity Protection (SIP, also known as “rootless”) will prevent you from creating links in /usr/lib/.
You could disable SIP by following these instructions, but you can create a link in /usr/local/lib/ instead:

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

More Related Contents:

  1. Visibility of global variables in imported modules
  2. pip install mysql-python fails with EnvironmentError: mysql_config not found
  3. “Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python
  4. mysql_config not found when installing mysqldb python interface
  5. mysql-python install error: Cannot open include file ‘config-win.h’
  6. How to insert pandas dataframe via mysqldb into database?
  7. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  8. Install mysql-python (Windows)
  9. When to close cursors using MySQLdb
  10. Installing mysqlclient in Python 3.6 in windows
  11. Python MYSQL update statement
  12. Python 3.4.0 with MySQL database
  13. How can I use executemany to insert into MySQL a list of dictionaries in Python
  14. Python MySQLdb execute table variable [duplicate]
  15. Python and MySQLdb: substitution of table resulting in syntax error
  16. MySQL: Get column name or alias from query
  17. ImportError: No module named MySQLdb
  18. Print the actual query MySQLdb runs?
  19. cursor.fetchall() vs list(cursor) in Python
  20. Can’t install mysql-python (newer versions) in Windows
  21. Dynamic SQL Queries with Python and mySQL
  22. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  23. Python MySQLDB: Get the result of fetchall in a list
  24. How to use python mysqldb to insert many rows at once
  25. About MySQLdb conn.autocommit(True)
  26. ‘pip install MySQL-python’ fails with ‘IndexError’
  27. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  28. ModuleNotFoundError: No module named ‘MySQLdb’
  29. How to disable query cache with mysql.connector
  30. What’s the most efficient way to convert a MySQL result set to a NumPy array?

Leave a Comment