Installation and configuration under Windows platform mysql5.7

Bo main QQ:819594300

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

Have any questions friends can contact Bo Master, Bo Master will help you answer, thank you for your support!

Installing mysql5.7 on Windows requires Administrator privileges on the system.

Windows two types of mounting options are available under the platform:

1 , MySQL binary distribution (. msi installation file)

2 , free install version (. zip compressed file)

In general, we use a binary distribution because it is simpler to use than other distribution versions, and it is no longer necessary to run MySQL without the need for other tools to start.

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

Download the MySQL installation file

In the browser input:

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

Depending on the following, select the Microsoft Windows platform, and then select the 32-bit or 64-bit installation package based on the platform. Here I choose the 32-bit. Click the Download button on the right to start the download.

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzsXA3CoQAAFWXbaZSNs488.jpg "style=" float : none; "title=" image001.jpg "alt=" wkiom1mfzsxa3coqaafwxbazsns488.jpg "/>650" this.width=650; "src=" https:// S2.51cto.com/wyfs02/m00/9d/c7/wkiom1mfzswwx3hlaacv5f5uiju878.jpg "style=" Float:none; "title=" Image002.jpg "alt=" Wkiom1mfzswwx3hlaacv5f5uiju878.jpg "/>

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M02/9D/C6/wKioL1mFzsbAkxPAAACvx-MhXBs570.jpg "style=" float : none; "title=" image003.jpg "alt=" Wkiol1mfzsbakxpaaacvx-mhxbs570.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/9D/C7/wKiom1mFzsfCmKx5AAGK9VeJ74U637.jpg "style=" float : none; "title=" image004.jpg "alt=" Wkiom1mfzsfcmkx5aagk9vej74u637.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/9D/C6/wKioL1mFzsew-37xAAD_lJ_Eo0w364.jpg "style=" float : none; "title=" image005.jpg "alt=" Wkiol1mfzsew-37xaad_lj_eo0w364.jpg "/>

Attention:

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

mysql-install-community is an offline installation version

Here I chose the mysql-install-community offline installation version

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/9D/C6/wKioL1mFzsjBlL9MAAEgql5XQvc079.jpg "style=" float : none; "title=" image006.jpg "alt=" Wkiol1mfzsjbll9maaegql5xqvc079.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzsnSeG63AAEJEX3GQ-I943.jpg "style=" float : none; "title=" image007.jpg "alt=" Wkiom1mfzsnseg63aaejex3gq-i943.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzsniYvzUAADw5WJRz-Q184.jpg "style=" float : none; "title=" image008.jpg "alt=" Wkiom1mfzsniyvzuaadw5wjrz-q184.jpg "/>

Second, installation mysql5.7

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/9D/C6/wKioL1mFzsqDHsa4AAF8W8Ge5kg020.jpg "style=" float : none; "title=" image009.jpg "alt=" Wkiol1mfzsqdhsa4aaf8w8ge5kg020.jpg "/>

①developer defaults (default installation type)

②server only (as server only)

③client only (as client only)

④full (fully installed)

⑤custom (Custom Installation type)

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M02/9D/C6/wKioL1mFzsvTYVnKAAHYLG0ooBk317.jpg "style=" float : none; "title=" image010.jpg "alt=" Wkiol1mfzsvtyvnkaahylg0oobk317.jpg "/>

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/9D/C7/wKiom1mFzsuTa4qAAAGAMfwW7JY870.jpg "style=" float : none; "title=" image011.jpg "alt=" Wkiom1mfzsuta4qaaagamfww7jy870.jpg "/>

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M00/9D/C6/wKioL1mFzszT1Z53AAFyx9blSF0575.jpg "style=" float : none; "title=" image012.jpg "alt=" Wkiol1mfzszt1z53aafyx9blsf0575.jpg "/>

Third, configuration mysql5.7

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzs3hgHldAAF05XltoY8285.jpg "style=" float : none; "title=" image013.jpg "alt=" Wkiom1mfzs3hghldaaf05xltoy8285.jpg "/>

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/9D/C6/wKioL1mFzs6z45kuAAHX5j7O4UQ122.jpg "style=" float : none; "title=" image014.jpg "alt=" Wkiol1mfzs6z45kuaahx5j7o4uq122.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/9D/C7/wKiom1mFzs7Sz-AGAAGzwCI3Yr0422.jpg "style=" float : none; "title=" image015.jpg "alt=" Wkiom1mfzs7sz-agaagzwci3yr0422.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/9D/C6/wKioL1mFztDiFtXrAAK5MX7bLho002.jpg "style=" float : none; "title=" image016.jpg "alt=" Wkiol1mfztdiftxraak5mx7blho002.jpg "/>

Mysql the meaning of individual parameters in the Server Configuration window is as follows:

Configtype : This option sets the type of server, click the Down button to the right of the option, and you can see that he includes three options, respectively, as explained below:

Development Machine (development machine) : This option represents a typical personal desktop workstation. Assume that there are multiple desktop applications running on the machine. Configure the MySQL server to use minimal 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 scale of system resources.

Dedicated Machine (dedicated server) : This option represents a server that only runs the MySQL service. Assume that no other service program is running. Configure the MySQL server to use all available system resources.

Note : As a beginner, we recommend the choice of development machine (development machines), as this only takes up a small portion of our computer system resources.

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/9D/C6/wKioL1mFztDS9Z-5AAIOkrFrejw520.jpg "style=" float : none; "title=" image017.jpg "alt=" Wkiol1mfztds9z-5aaiokrfrejw520.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/9D/C7/wKiom1mFztGgReZ2AAHFIeBryNQ534.jpg "style=" float : none; "title=" image018.jpg "alt=" Wkiom1mfztggrez2aahfiebrynq534.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/9D/C7/wKiom1mFztLQZz2VAAH0rHEQ8Us798.jpg "style=" float : none; "title=" image019.jpg "alt=" Wkiom1mfztlqzz2vaah0rheq8us798.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/9D/C6/wKioL1mFztKB8UD-AAF4bJ409gk649.jpg "style=" float : none; "title=" image020.jpg "alt=" Wkiol1mfztkb8ud-aaf4bj409gk649.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/9D/C7/wKiom1mFztPQGQ_5AAGj_kXiLGQ114.jpg "style=" float : none; "title=" image021.jpg "alt=" Wkiom1mfztpqgq_5aagj_kxilgq114.jpg "/>

In this way, MySQL server configuration installation, at this time we press Ctrl+alt+del combination, you can see in "Windows Task Manager" the MySQL server process Mysqld.exe has been started

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/9D/C6/wKioL1mFztXQbBtBAANB0uHAG-8137.jpg "style=" float : none; "title=" image022.jpg "alt=" Wkiol1mfztxqbbtbaanb0uhag-8137.jpg "/>

Iv. start the MySQL service and log in to the MySQL database

In the previous configuration process, MySQL was 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 at the command line.

The following is viewed through the Windows Service Manager, as follows:

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/9D/C6/wKioL1mFztWB5i3UAAEPwrFGuMU200.jpg "style=" float : none; "title=" image023.jpg "alt=" Wkiol1mfztwb5i3uaaepwrfgumu200.jpg "/>

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/9D/C7/wKiom1mFztbhFAUoAAB48O7IhwE434.jpg "style=" float : none; "title=" image024.jpg "alt=" Wkiom1mfztbhfauoaab48o7ihwe434.jpg "/>

You can see that the service item status for MySQL is "running"

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzteTT_cWAAKUdIo6ziI870.jpg "style=" float : none; "title=" image025.jpg "alt=" Wkiom1mfztett_cwaakudio6zii870.jpg "/>

If there is no "running" word stating that the MySQL service is started, the workaround is:

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/9D/C6/wKioL1mFztej6AEsAAETgu6tDkY060.jpg "style=" float : none; "title=" image026.jpg "alt=" Wkiol1mfztej6aesaaetgu6tdky060.jpg "/>

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/9D/C6/wKioL1mFztjiHKoqAAFHhrnZIIU005.jpg "style=" float : none; "title=" image027.jpg "alt=" Wkiol1mfztjihkoqaafhhrnziiu005.jpg "/>

To stop the MySQL service, the command is "net stop MySQL"

Note : MySQL Here is the name of the service, if your MySQL service name is not MySQL, then you need to replace it with your own.

below we log in to MySQL database :

There are two ways to log in to a MySQL database.

1 ) Log on as Windows command line

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/9D/C7/wKiom1mFztnwua3eAAEYd4NDnmw715.jpg "style=" float : none; "title=" image028.jpg "alt=" Wkiom1mfztnwua3eaaeyd4ndnmw715.jpg "/>

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/9D/C7/wKiom1mFztqSDo-hAAJFvF36cxg498.jpg "style=" float : none; "title=" image029.jpg "alt=" Wkiom1mfztqsdo-haajfvf36cxg498.jpg "/>

2 ) login with Mysqlcommand line client

Start-All Programs-mysql-mysqlserver5.7-mysql 5.7 commandline client

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/9D/C6/wKioL1mFztqBNVnHAAD2ZukS0Wg912.jpg "style=" float : none; "title=" image030.jpg "alt=" Wkiol1mfztqbnvnhaad2zuks0wg912.jpg "/>

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/9D/C6/wKioL1mFztuQa59kAABSwWqgZQc863.jpg "style=" float : none; "title=" image031.jpg "alt=" Wkiol1mfztuqa59kaabswwqgzqc863.jpg "/>

Description : mysql5.7.19 The My.ini configuration file in the location as shown:

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/9D/C7/wKiom1mFztuz1pDpAACD3EBDBNY933.jpg "style=" float : none; "title=" image032.jpg "alt=" Wkiom1mfztuz1pdpaacd3ebdbny933.jpg "/>

V. Configuring the PATH variable

The mysql login command cannot be entered directly in front of MySQL, because the MySQL bin directory is not added to the environment variables of the system, so it cannot be.

It is cumbersome to enter C:\Program Files\mysql\mysql server5.7\bin every time you log in to MySQL.

Configure the path variable to do the following:

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M00/9D/C7/wKiom1mFzwGz4dtYAAFWL3VE1eg377.jpg "style=" float : none; "title=" image033.jpg "alt=" Wkiom1mfzwgz4dtyaafwl3ve1eg377.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/9D/C6/wKioL1mFzwLylvyVAACtfMqBiMU414.jpg "style=" float : none; "title=" image034.jpg "alt=" Wkiol1mfzwlylvyvaactfmqbimu414.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M01/9D/C6/wKioL1mFzwPAgBFyAAKhDWtmE2I849.jpg "style=" float : none; "title=" image035.jpg "alt=" Wkiol1mfzwpagbfyaakhdwtme2i849.jpg "/>

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/9D/C7/wKiom1mFzwTgB-IkAALLUeoN3QA555.jpg "style=" float : none; "title=" image036.jpg "alt=" Wkiom1mfzwtgb-ikaallueon3qa555.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M01/9D/C7/wKiom1mFzwbisQpaAANwsPOZlg0116.jpg "style=" float : none; "title=" image037.jpg "alt=" Wkiom1mfzwbisqpaaanwspozlg0116.jpg "/>

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M02/9D/C6/wKioL1mFzwej9tkVAAO9bUESN6k257.jpg "style=" float : none; "title=" image038.jpg "alt=" Wkiol1mfzwej9tkvaao9buesn6k257.jpg "/>

Test it:

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/9D/C6/wKioL1mFzwijdPzBAAHpaVQ_j6s520.jpg "style=" float : none; "title=" image039.jpg "alt=" Wkiol1mfzwijdpzbaahpavq_j6s520.jpg "/>

Vi. MySQL common graphical management tools

Common graphical management tools include the following:

Mysqlworkbench

PhpMyAdmin

Navicat

Mysqldumper

SQLyog

Mysqlodbc Connector

Among them, Navicat and phpMyAdmin provide a Chinese user interface

MySQL Workbench, Mysqldumper, SQLyog, and MySQL ODBC Connector provide an English-language operator interface.

Here are a few separate explanations:

1 , Mysqlworkbench

MySQL is the official graphical management tool, it fully supports mysql5.0 and above version. There are some features that are not available in the 5.x version, and in the 4.x version, MySQL Workbench is divided into community and commercial editions, where the Community edition is completely free and the commercial version is billed annually.

Is:

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

2 , PhpMyAdmin

Written in PHP, you must be installed on a Web server to control and manipulate the MySQL database in a web-based manner. The database can be fully manipulated by phpmyadmin, such as creating, copying, deleting databases, and so on. The main thing is that he supports Chinese, but its disadvantage is that it is inconvenient for backup and recovery of large databases.

Is:

http://www.phpmyadmin.net/

3 , Navicat

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

Is:

http://www.navicat.com/

4 , Mysqldumper

Use PHP-based MySQL database backup and recovery program to solve the problem of large database backup and recovery using PHP. The hundreds of trillion database can be easily backed up and restored without worrying about interruptions caused by slow internet speeds.

Is:

http://www.MYSQLdumper.de/en/

5 , Sqllog

Simple, efficient and powerful graphical MySQL database management tool. Using Sqllog, you can quickly and intuitively maintain a remote MySQL database from any point in the world through the network.

Is:

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

You can also search the Internet to use the Chinese version of the hack, very useful.

This article is from the IT Technical Assistant blog, so be sure to keep this source http://zpf666.blog.51cto.com/11248677/1953895

Installation and configuration under Windows platform mysql5.7