Errors and solutions encountered when installing MySQLdb

This article mainly introduces the problems and solutions encountered when installing python MySQLdb under Windows. Friends in need can refer to the following

Preface: Because of work needs, build the environment MySQL+Python+ on CentOS MySQLdb, I am more accustomed to the operating habits of Windows systems, and I am not used to pure character OS yet. Therefore, I hope to build a similar environment on Windows systems for development. The following describes the process of compiling MySQLdb in the Windows environment. One additional sentence: I recently searched for a Windows installation package for MySQLdb on the Internet, which will be more convenient to use. The address: http://www.codegood.com/archives/4

mysql-connector-python is MySQL The driver program provided by the official website specifically connects to Python; it is very convenient to use. There are many program examples in the file for reference.

The process of manually compiling MySQLdb is as follows:

The download address of the software needed above is listed below:

MySQL - www.mysql. com/

Python - www.python.org/

MySQLdb - sourceforge.net/projects/mysql-python/

1. Install MySQL, select Custom, and then check "C Include Files / Lib Files". If using Typical, there will be a problem (1), and the following configurations are basically the default options, except for the additional checkbox "Include Bin Directory in Windows PATH". If you are not very clear about installing MySQL, you can search it on the Internet. There are many related articles

2. Install Python, which is basically the default option, just change the installation path slightly. The default installation path of Python is "C:/Python26". My personal habit is to change it to "C:/Program Files/Python26"

3. You must install setuptools before installing MySQLdb, otherwise compilation errors will occur. .

Setuptools - http://pypi.python.org/pypi/setuptools

Just install this tool by default...

Okay, you can officially start the installation MySQLdb. The tar.gz we downloaded is a source code package. There is no installation program in it. It needs to be compiled first and then installed.

(1) Unzip MySQL-python-1.2.3.tar.gz to the current directory, and a MySQL-python-1.2.3 folder will appear;

(2 ) WIN+R, open the run dialog box, enter cmd, open MS-DOS, and enter the folder decompressed above; (The premise is that you must understand what the cd command is:-)....)

(3) Enter setup.py build to start compilation...variables. >

I encountered the following problems during the compilation process:

1) Problem: _mysql.c(34): fatal error C1083: Cannot open include file: 'config-win.h ': No such file or directory
error: command '"C:/Program Files/Microsoft Visual Studio 9.0/VC/BIN/cl.exe"' failed with exit status 2

Reason: The reason is The C language library was not installed when installing MySQL.

Solution: Rerun the MySQL installation program, select Modify, check "C Include Files / Lib Files", and install.

2) Question: Traceback (most recent call last):
File "setup.py", line 15, in
metadata, options = get_config()
File "C:/MySQL-python-1.2.3/setup_windows.py", line 7, in get_config
serverKey = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, options['registry_key'])
WindowsError: [Error 2 ] The system cannot find the file specified

Cause: MySQL for python 1.2.3 is still looking for the version of MySQL5.0

Solution: 1. Open the site.cfg file in the directory and modify it The last behavior"registry_key = SOFTWARE/MySQL AB/MySQL Server 5.1"
2. Open the setup_windows.py file and modify the seventh line to "serverKey = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, 'SOFTWARE/ MySQL AB/MySQL Server 5.1')"

3) Problem: build/temp.win32-2.7/Release/_mysql.pyd.manifest: general error c1010070: Failed to load and parse the manifest. The system cannot find the file specified.
error: command 'mt.exe' failed with exit status 31

Cause: The path has changed?

Solution: Open the file "your PYTHON installation directory/Lib/distutils/msvc9compiler.py", find the line of code "ld_args.append('/MANIFESTFILE:' + temp_manifest)", and change it to " ld_args.append('/MANIFEST')"

(4) After the compilation is completed, you can enter setup.py install. Now you are finally done!

You can enter the following command in the DOS environment for testing:

C:/Users/Michael>python
Python 2.6.6 (r266:84297, Aug 24 2010, 18:46:32) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>

[Related recommendations]

1. Python free video tutorial

2. Python meets data collection video tutorial

3. python learning manual

The above is the detailed content of Errors and solutions encountered when installing MySQLdb. For more information, please follow other related articles on the PHP Chinese website!