Shulou(Shulou.com)06/01 Report--

Blogger QQ:819594300

Blog address: http://zpf666.blog.51cto.com/

Friends who have any questions can contact the blogger, the blogger will help you answer, thank you for your support!

Installing mysql5.7 on windows requires administrator privileges on the system.

Two installation methods are available on the Windows platform:

1. Mysql binary distribution (.msi installation file)

2. Installation-free version (.zip zip file)

In general, we use a binary distribution because it is easier to use than other distributions and no longer requires other tools to launch to run mysql.

This example takes the window7 platform as an example for graphical binary installation, and the installation process is similar on other windows platforms.

Download the mysql installation file

Enter in the browser:

Http://dev.mysql.com/downloads/installer/

According to the screenshot below, select the Microsoft windows platform, and then choose a 32-bit or 64-bit installation package based on the platform. Here I choose 32-bit. Click the [download] button on the right to start the download.

Note:

Mysql-install-web-community is an online installation version

Mysql-install-community is an offline installation version

Here I chose the offline installation version of Mysql-install-community

Second, install mysql5.7

① developer default (default installation type)

② server only (server only)

③ client only (as client only)

④ full (full installation)

⑤ custom (Custom installation Type)

3. Configure mysql5.7

Individual parameters in the Mysql server configuration window have the following meanings:

Configtype: this option is used to set the type of server. Click the down button on the right side of this option, and you can see that it includes three options, which are explained as follows:

Development machine (development machine): this option represents a typical personal desktop workstation. Suppose there are multiple desktop applications running on the machine. Configure the mysql server to use the least system resources.

Server machine (server): this option represents the server, and the mysql server can run with other applications, such as ftp, email, and web servers. Configure the Mysql server to use the appropriate proportion of system resources.

Dedicated machine (dedicated server): this option represents a server that runs only the mysql service. Assume that no other service programs are running. Configure the mysql server to use all available system resources.

Note: as beginners, it is recommended to choose Development machine (development machine) when we practice, because this only temporarily uses a small part of the resources of our computer system.

In this way, the mysql server is configured and installed. When we press the Ctrl+alt+del key combination, we can see that the mysql server process mysqld.exe has been started in the [windows Task Manager].

Start mysql service and log in to mysql database

In the previous configuration process, mysql has been installed as a windows service, and when windows starts and stops, mysql automatically starts and stops.

However, you can use the graphical service tool to control the mysql server or use the NET command on the command line.

The following is viewed through the service manager of windows, and the actions are as follows:

You can see that the service item status of mysql is running

If the word "running" is not available, the mysql service is started. The solution is:

To stop the mysql service, the command is "net stop MYSQL"

Note: the MYSQL here is the name of the service. If the name of your mysql service is not MYSQL, you need to change it to your own.

Let's log in to the mysql database:

There are two ways to log in to the mysql database.

1) Log in as windows command line

2) Log in using mysqlcommand line client

Start-all programs-mysql-mysqlserver5.7-mysql 5.7commandline client

Description: the my.ini configuration file for mysql5.7.19 is located as shown in the following figure:

Configure Path variables

You cannot enter the mysql login command directly when you log in to mysql, because the bin directory of mysql has not been added to the system's environment variable, so you cannot.

It would be troublesome to enter C:\ Program Files\ MySQL\ MySQL Server5.7\ bin every time you log in to mysql.

Configure the Path variable as follows:

Test it:

VI. Common graphics management tools for mysql

Common graphical management tools are as follows:

MySQLWorkbench

PhpMyAdmin

Navicat

MySQLDumper

SQLyog

MySQLODBC Connector

Navicat and phpMyAdmin provide Chinese operation interface.

MySQL Workbench, MySQLDumper, SQLyog and MySQL ODBC Connector provide English interface.

The following are explained separately:

1 、 MySQLWorkbench

Is an official graphical management tool provided by mysql, which fully supports versions above mysql5.0. There are some features that are not available in the 5.x version, while in the 4.x version, MySQL Workbench is divided into the community version and the commercial version, where the community version is completely free, while the commercial version is charged on an annual basis.

The download address is:

Http://dev.MYSQL.com/downloads/workbench/

2 、 phpMyAdmin

Written in PHP, it must be installed in the web server to control and operate the mysql database through web. Through phpMyAdmin, you can completely operate the database, such as establishing, copying, deleting the database, and so on. The most important thing is that he supports Chinese, but its disadvantage is that it is not convenient for the backup and recovery of large databases.

The download address is:

Http://www.phpmyadmin.net/

3 、 Navicat

It is fully compatible with any version of mysql3.21 or above, supporting triggers, stored procedures, functions, events, views, administrative users, and so on. It is easy for beginners to learn and understand. Navicat supports Chinese and is available in a free version.

The download address is:

Http://www.navicat.com/

4 、 MySQLDumper

The backup and recovery program of mysql database based on PHP is used to solve the problem of backup and recovery of large database with PHP. Hundreds of megabytes of databases can be easily backed up and restored. There is no need to worry about the interruption caused by the slow network speed. It is very easy to use.

The download address is:

Http://www.MYSQLdumper.de/en/

5 、 SQLlog

Concise, efficient and powerful graphical mysql database management tool. Using SQLlog allows users to quickly and intuitively maintain remote mysql databases through the network from any point of view in the world.

The download address is:

Http://www.webyog.com/en/index.php

You can also search the Chinese cracked version on the Internet to use it, which is very easy to use.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.