Install MySQL and use MySQLdb in python

Why MySQL is used? Because MySQL is small and exquisite and has powerful performance. Regardless of the capacity, compared to the other two (SQL server, oracle), it is just a few G, dozens of G big software installed on the computer, to use smoothly, no higher configuration is required. In addition, although MySQL is easy to use, but you want to interact with python, you generally think of "pip install MySQL-python", and a bunch of error messages are often reported, online search offline package installation tutorials cannot be solved... How headaches do you know when a pair of child shoes are tossing -_-!!

This article consists of three parts:

(1) install MySQL;

(2) install and use the MySQL graphical interface tool;

(3) install and use the mysqdb Library.

I personally test the installation steps below for these three sections, and can finally use them. (N pitfall occurred ..?? Z)

1. Download, install, configure, and use MySQL

Software download:

Http://dev.mysql.com/downloads/mysql/5.6.html

The ZIP Archive version is used here, and the 64-bit win7 machine supports this, so I suggest using this. This is simple and clean.

Pull down the bottom, clear the 64bit ZIP Archive, and click Download.

The author has already completed this article, and there is a way to get it at the end of the article. It is recommended that you download version 5.6, which is easy to find on the official website. However, a data folder is missing after the installation package of this version is decompressed, so that the mysql service cannot be enabled after installation... You also need to find the file configuration !!

The ZIP Archive version is free of installation. You just need to decompress the package. It is no different from the installation version, but it does not need to be installed. Find the downloaded mysql-x.x.xx-winx64.zip file, right-click it, and select (decompress it ...), find the place you want to install. If you like C: Disk, select C: Disk. If you don't like it, select c: Disk. Here, D: Disk. After all, C: it is not good to store too many items on the system disk. After decompression, it will be OK.

After MySQL is installed, the next step is to install and use MySQL GUI Tools.

In addition, we recommend the python data analysis environment Anaconda + pycharm combination. Anaconda already has many packages used for data analysis, such as Numpy, Scipy, and matplotlib. cmd enters the command line console, enter the conda list to view all Python packages that come with installation. Enter the pip install package name to install other packages that you need. Pycharm provides the code automatic prompt function to provide the encoding speed.