Compile and install MySQL in Linux-Python tutorial

This article mainly introduces how to compile and install MySQL-Python in Linux. This article uses the compilation method for installation, provides and tests the method for successful installation. For more information, see 1. download mysql-python

Address: http://sourceforge.net/projects/mysql-python/

2. install mysql-python

The code is as follows:

# Tar-zxvf MySQL-python-1.2.3.tar.gz
# Cd MySQL-python-1.2.3
# Whereis mysql_config
Mysql_config:/usr/bin/mysql_config/usr/share/man/man1/mysql_config.1.gz
# Vi site. cfg
Threadsafe = False
Mysql_config =/usr/bin/mysql_config
# Whereis mysql
Mysql:/usr/bin/mysql/usr/lib/mysql/usr/include/mysql/usr/share/man/man1/mysql.1.gz
# Export LD_LIBRARY_PATH =/usr/include/mysql
# Python setup. py build
# Python setup. py install

Note:
1. to compile mysql-python, the mysql header file is required.
2. to install mysql-python, you need the setuptools tool.

3. test

The code is as follows:

# Python
>>> Import MySQLdb
>>>

If there is no error prompt or the following error prompt, the installation is successful.

Error message:

The code is as follows:

/Usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_ mysql. py: 3: UserWarning: Module _ mysql was already imported from/usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_ mysql. pyc, but/root/MySQL-python-1.2.3 is being added to sys. path

Error cause:

Run python setup. py install. the MySQLdb module will be copied to the python site-packages directory. If the same module exists in the directory where python is executed, the module may be imported again.

Solution:

Run python in another directory.