How to install and configure mysql5.6: graphic tutorial, how to install and configure mysql5.6

How to install and configure mysql5.6: graphic tutorial, how to install and configure mysql5.6

I also learned python from scratch. However, when I have just processed the data, I need to use a database to store the data. So I have to configure the mysql database because it is actually operated on a lab machine, restrictions on the machine environment (failed to install mysql), so mysql is used in a lower mysql version. The following describes how to install mysql-server, because I use python to operate the database, there is no need to use the client. I just need to install the server. Let's start now!

1. Download the installation package: URL: Download the mysql-server package and decompress it.

2. decompress the file as follows. We need to modify some items in the my-default file, that is, add some paths. The path name is related to the place where you place the files. Remember not to stick to it.

3. This is almost done. Now we can use cmd to configure something.Administrator permission to open cmd (otherwise the permission is insufficient),

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. After installation, use net start mysql to start mysql.

Here, the mysql database is installed. At this time, our user master is root and the password is blank. Therefore, you can enter the following during the first login:

Mysql-u root-pPress enter when prompted to enter the password.

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

You can go to cainiao or MOOC to learn how to use mysql. However, I still provide a simple statement to illustrate the basic operations, however, you also need to install a plug-in when operating mysql in python. Its url is as follows:

Simple Example:

Import MySQLdb # link database db = MySQLdb. connect ('localhost', 'root', ''," test ", 3306) # mysql uses the following variables to use cursor = db. cursor () SQL = "" CREATE TABLE Location (Time CHAR (15), Latitude CHAR (15), long1_char (15), Altitude CHAR (10 )) "pipeline executes cursor.exe cute (SQL) # The above is a simple demonstration of python operations on mysql

Address: http://blog.csdn.net/zr1076311296/article/details/51700464

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.