Mysql5.6 installation and configuration method graphic tutorial_MySQL

I also started learning python from scratch. However, after I had just processed the data, I had to use a database to store the data, so I had to equip the mysql database because it was necessary to operate on a machine in the laboratory due to the limitations of the machine environment. (The installation of mysql5.7 version failed), so I still use the lower version of mysql, mysql5.6. Let’s talk about how to install mysql-server. Because I use python to operate the database, there is no need to use the client. , you only need to install the server, let’s get started!

1. First download the installation package: URL: Download mysql-server After downloading, unzip it.

2. The file after decompression is as follows. We need to modify some things in the my-default file, that is, add some paths. The path name is related to where you place it. Remember not to copy it mechanically.

3. This is almost done. Now just use cmd to configure a few more things. We use administrator rights to open cmd (otherwise the rights are not enough) ,

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

5. Enter the following command: mysqld -install

6. After successful installation, you can start the server and use mysql. After installation, use net start mysql to start mysql

The mysql database is installed here. At this time, our user name is root and the password is empty, so when logging in for the first time, you can enter:

mysql -u root -p Just press Enter when prompted to enter the password.

The above is the installation of the compressed version of mysql. Mysql also has mysql in .msi format. The installation of mysql in this format is relatively simple. The installation process has a graphical interface. When selecting the type, choose to install only the server. Yes, after the installation is completed, it will generate a shortcut. You can click this shortcut to start mysql-server

About how to use mysql, you need to explain separately. You can go to Cainiao Online Learning or MOOC to learn it. However, here I will provide a simple statement to explain the basic operation. However, python operates mysql. You also need to install a plug-in, the URL of which is as follows: python operation mysql library

Simple example:

import MySQLdb

#链接数据库
db = MySQLdb.connect('localhost','root','',"test",3306)

#mysql一系列操作都是通过下面的变量来使用
cursor = db.cursor()

sql="""CREATE TABLE Location(
  Time CHAR(15),
  Latitude CHAR(15),
  Longitude CHAR(15),
  Altitude CHAR(10))"""

#执行
cursor.execute(sql)

#以上只是简单的演示了一下python操作mysql

Original address: http://blog.csdn.net/zr1076311296/article/details/51700464

The above is the entire content of this article. I hope it will be helpful to everyone’s study and I hope you will support me a lot.