MySQL is the widely used interface between Python and MySQL. So, for having MySQL Python for Windows, you will need to follow these following steps.
- Firstly, install python setuptools, if you have done it already, then doesn’t need to do so.
- Make sure that you have MySQL Developer Components installed or not.
- Download MySQL msi installer version, then select “Developer Components” in Custon setup. It will install C:/ProgramFiles/MySQL/MySQL Server 5.1/include, lib/debug and lib/opt for you.
- Now, uncompress MySQL-python-1.2.3c1.tar.gz into a directory. Now, open the command window and change it to the directory.
- Run “setup.py build”
- You can check for the version used by you by using regedit, which is specified at :- HKEY_LOCAL_MACHINE/SOFTWARE/MySQL AB/MySQL Server 5.1
- When “setup.py build” runs, you now run “setup.py install”
- Now test it in python and import MySQLdb
- And now you are done.
This multi-user, multithreaded SQL database management system is presently owned by Oracle Corporation with having eleven million plus installations. You can use these steps to get MySQL Python for Windows, as it is reliable, fast, secure and easy to use. This mostly used open source DBMS is very useful for Python files.
Tags: mysql python, MySQL Python Windows