mysql-python installation problems (on mac os x lion)

by

I think there might be slight quirks with doing this on Mac 64-bit (and if you google this problem shows up a lot too).

I’ve run into it, and there are a couple things you can do:

Override the environment

You can change the DYLD_LIBRARY_PATH environment variable, which tells the linker where to look for dynamic libraries (.so files and such). You said you also downloaded the 64-bit version of MySQL, so where ever it’s installed, change the path you see here:

In a shell:

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

And then run python and see if you can import MySQLdb.

If that works, you can make this permanent by altering your shell profile (.bash_profile, most likely).

Use homebrew

I don’t really like mucking around with making sure MySQL and Python and all that are correct architectures and installing them separately. I run homebrew, which is a sort of package manager for Mac. If you install that, you can pretty easily take care of this issue:

  • brew install python
  • brew install mysql
  • /usr/local/share/python/easy_install mysql-python

Do note that homebrew installs into /usr/local, so you should add /usr/local/bin to your PATH, ahead of /usr/bin and /bin, otherwise you’ll get really confused why python is different.

You can add /usr/local/share/python to your PATH as well, to make it permanent.

More Related Contents:

  1. How do I install pip on macOS or OS X?
  2. How to install PIL with pip on Mac OS?
  3. How to set Python’s default version to 3.x on OS X? [duplicate]
  4. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  5. Mac OS X – EnvironmentError: mysql_config not found
  6. Too many different Python versions on my system and causing problems
  7. Installing MySQL Python on Mac OS X
  8. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  9. pip installation /usr/local/opt/python/bin/python2.7: bad interpreter: No such file or directory
  10. Python import MySQLdb error – Mac 10.6
  11. What is the best way to Install Conda on MacOS (Apple/Mac)?
  12. Install mysqlclient for Django Python on Mac OS X Sierra
  13. Upgrade Python to 2.6 on Mac
  14. How to insert a space delimited text file into mysql using Python? [closed]
  15. Working with an Access database in Python on non-Windows platform (Linux or Mac)
  16. Installing SciPy with pip
  17. How to change the foreground or background colour of a Tkinter Button on Mac OS X?
  18. Database does not update automatically with MySQL and Python
  19. Python: best practice and securest way to connect to MySQL and execute queries
  20. python matplotlib framework under macosx?
  21. Broken references in Virtualenvs
  22. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  23. SQLAlchemy ON DUPLICATE KEY UPDATE
  24. DistutilsOptionError: must supply either home or prefix/exec-prefix — not both
  25. socket.error: [Errno 48] Address already in use
  26. “RuntimeError: Make sure the Graphviz executables are on your system’s path” after installing Graphviz 2.38
  27. Python Sound (“Bell”)
  28. Repeated MySQL queries from Python return the same data [duplicate]
  29. Python mySQL Update, Working but not updating table
  30. Warning raised by inserting 4-byte unicode to mysql

Leave a Comment