MySQL Server installation

I also started from 0 to learn python, but just processing the data, I have to use the database to store the data, so I have to put the MySQL database well, because the actual laboratory machine operation, machine environment restrictions (installed over the mysql5.7 version of the failure), So using a lower version of MySQL mysql5.6, the following is how to install mysql-server, because I use Python to operate the database, so no need to use the client, just install the server, the following start!

1. First download the installation package: URL: Download Mysql-server after downloading, unzip.

2. Unzip the file as follows, we need to change something in the My-default file, that is, add some path, path name and where you place, remember not mechanically oh.

3. This completes almost, the following will use CMD to configure a bit of something, we use Administrator privileges to open cmd (otherwise insufficient permissions),

4. Switch to the bin directory under the MySQL directory under cmd

5. Enter the following command: Mysqld-install

6. After the installation is successful, you can start the server and use MySQL, install the net start MySQL to start MySQL.

MySQL database is installed here, this time our user master root, password is empty, so the first time you log in can enter:

mysql-u root-p when prompted to enter the password, you can return directly.

The above is a compressed version of MySQL installation, MySQL also has the. msi format of MySQL, this format of MySQL installation is relatively simple, his installation process has a graphical interface, choose the type of time to choose only the server can be installed, after the installation of it will generate a shortcut, you click on this shortcut can be launched after Mysql-server

about how to use MySQL this needs to be explained, you can go to the novice online learning or MU class online can learn , but here I would like to provide a simple statement to illustrate the basic operation, but Python operation MySQL also need to install a plug-in, the URL is as follows: Python operation MySQL library

Simple example:

Import mysqldb# link Database db = MySQLdb.connect (' localhost ', ' root ', ' ', ' test ', 3306) #mysql一系列操作都是通过下面的变量来使用cursor = Db.cursor () sql= "" "CREATE TABLE location (Time        char (+),        Latitude char (+),        longitude char ()        , Altitude CHAR (Ten)) "" "#执行cursor. Execute (SQL) #以上只是简单的演示了一下python操作mysql

MySQL Server installation