Today, when setting up the DJANGO+MYSQL environment, I encountered a few problems and recorded it.
Installation environment: OS X 10.10 operating system, Python 2.7.
MySQLdb is actually included in the Mysql-python package, so you should search for Mysql-python whether you download or search in PIP.
The following describes two common installation methods for MYSQLDB:
Download the installation or Pip install Mysql-python.
Source Installation
Download MySQLdb Source Code
Here is the version of 1.2.5
https://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.5.zip#md5=654f75b302db6ed8dc5a898c625e030c
Unzip the download, and then execute the following command in Terminal Terminal:
$ CD mysql-python-1.2.5
Then modify the Site.cfg to modify the following:
by #mysql_config =/usr/local/bin/mysql_config
Change to Mysql_config =/usr/local/mysql/bin/mysql_config
Otherwise, there will be no problem finding MySQL config:
File "/tmp/easy_install-nhssgl/mysql-python-1.2.2/setup_posix.py", line, in Mysql_config
Environmenterror:mysql_config not found
Then modify the _MYSQL.C and comment out the 37th to 39th line as follows:
#ifndef uint//#define UINT unsigned int//#endif
Otherwise, it will appear:
In file included from/usr/local/mysql/include/mysql.h:47, from _mysql.c:40:/usr/include/sys/types.h:92:error: Duplicate ' unsigned '/usr/include/sys/types.h:92:error:two or more data types in declaration Specifierserror:command ' GC C ' failed with exit status 1
Then use Python./setup.py build Compilation
$ python./setup.py Build
Then use Python./setup.py Install Installation
$ sudo python./setup.py Installpassword:
installing MYSQLDB with Pip
execute in Terminal: $ pip install mysql-python
There is no way to modify the Site.cfg file when using PIP installation, so you can resolve errors that cannot be found by modifying OS X's system environment variables.
Modify OS x environment variable : Open terminal, use VIM in terminal to open "~/.bash_profile", if no vim is installed, then show hidden file Open with text editor, the operation here is no longer described. In. Bash_profile, add the following:
Path="/usr/local/mysql/bin:${path}"
Export PATH
Export dyld_library_path=/usr/local/mysql/lib/
Export Versioner_python_prefer_64_bit=no
Export Versioner_python_prefer_32_bit=yes
Among them versioner_python_prefer_64_bit and versioner_python_prefer_64_bit according to their own installation of MySQL to choose.
Also provide a PIP installation can not find the Mysql_config solution, enter the following command in the terminal:
$ sudo ln-s/usr/local/mysql/bin/*/usr/bin
Here, the Mysql-python package should be installed basically smoothly.
Resolve Reason:image not found error
After installing the Mysql-python package, let us import mysqldb, there is an error, the last line of error is written reason:image not found.
The workaround is to execute at the terminal:
$ sudo ln-s/usr/local/mysql/lib/libmysqlclient.18.dylib/usr/lib/libmysqlclient.18.dylib
$ sudo ln-s/usr/local/mysql/lib/usr/local/mysql/lib/mysql
Test
Use the following command to test:
$ cd ~$ Pythonpython 2.5.1 (r251:54863, APR, 22:57:26) [GCC 4.0.1 (Apple Inc. build 5465)] on Darwintype "Help", " Copyright "," credits "or" license "for more information.>>> import mysqldb>>> mysqldb.apilevel ' 2.0 ' >>> Import django>>> Print Django. VERSION (1, 0, ' final ')
Common errors
Clang:error: unknown argument: '-mno-fused-madd' [- Wunused-command-line-argument-hard-error-in-future]
Clang:note:this'll be a hard error (cannot is downgraded to a warning) in the future
Verified on-line:http://www.tuicool.com/articles/zI7Vzu, seemingly Mac OS Xcode from 5.1 to compiler rules for unknown parameter incoming as error, we need to downgrade this error to warning using archflags, so the final installation command should look like this:
sudo archflags=-wno-error=unused-command-line-argument-hard-error-in-future python setup.py build
Python+django+mysql Configuration under Mac