Installing MySQL libmysqlclient-dev and UDF files on Mac OSX
try installing mysql-connector-c:
brew install mysql-connector-c
installing the mysqlclient library in mac OS
mysql-connector-c seems to be the homebrew package you are looking for. Libmysqlclient should also be installed when installing the mysql brew package.
How do I install command line MySQL client on mac?
install MySQLWorkbench, then
export PATH=$PATH:/Applications/MySQLWorkbench.app/Contents/MacOS
Mac OS X - EnvironmentError: mysql_config not found
Ok, well, first of all, let me check if I am on the same page as you:
- You installed python
- You did
brew install mysql
- You did
export PATH=$PATH:/usr/local/mysql/bin
- And finally, you did
pip install MySQL-Python
(orpip3 install mysqlclient
if using python 3)
If you did all those steps in the same order, and you still got an error, read on to the end, if, however, you did not follow these exact steps try, following them from the very beginning.
So, you followed the steps, and you're still geting an error, well, there are a few things you could try:
Try running
which mysql_config
from bash. It probably won't be found. That's why the build isn't finding it either. Try runninglocate mysql_config
and see if anything comes back. The path to this binary needs to be either in your shell's $PATH environment variable, or it needs to be explicitly in the setup.py file for the module assuming it's looking in some specific place for that file.Instead of using MySQL-Python, try using 'mysql-connector-python', it can be installed using
pip install mysql-connector-python
. More information on this can be found here and here.Manually find the location of 'mysql/bin', 'mysql_config', and 'MySQL-Python', and add all these to the $PATH environment variable.
If all above steps fail, then you could try installing 'mysql' using MacPorts, in which case the file 'mysql_config' would actually be called 'mysql_config5', and in this case, you would have to do this after installing:
export PATH=$PATH:/opt/local/lib/mysql5/bin
. You can find more details here.
Note1: I've seen some people saying that installing python-dev
and libmysqlclient-dev
also helped, however I do not know if these packages are available on Mac OS.
Note2: Also, make sure to try running the commands as root.
I got my answers from (besides my brain) these places (maybe you could have a look at them, to see if it would help): 1, 2, 3, 4.
I hoped I helped, and would be happy to know if any of this worked, or not. Good luck.
Related Topics
How to Handle a Single Quote in Oracle Sql
Get Value Based on Max of a Different Column Grouped by Another Column
Convert Datetime Column from Utc to Local Time in Select Statement
In VS Any Operator in Postgresql
How to Find Similar Results and Sort by Similarity
How to Return Result of a Select Inside a Function in Postgresql
How to Ignore Ampersands in a SQL Script Running from SQL Plus
SQL Server Recursive Self Join
How to Insert a Value That Contains an Apostrophe (Single Quote)
Grouping into Interval of 5 Minutes Within a Time Range
Sqlite Insert - on Duplicate Key Update (Upsert)
Foreign Key to Non-Primary Key
Multiple Insert Statements Vs. Single Insert With Multiple Values
Delete from Two Tables in One Query