mysql 5.7. 17 zip Compressed Package Installation Tutorial under win10

mysql 5.7. 17 Installation tutorial is shared with you for your reference. The specific contents are as follows

Download zip https://www.mysql.com/downloads/ from official website

Decompression

D:\devtool\mysql-5.7.17-winx64\

Add D:\ devtool\ mysql-5. 7.17-winx64\ bin to the environment variable

Right-click on the taskbar windows icon- > Command prompt (administrator), run cmd, cd through D as administrator:\ devtool\ mysql-5. 7.17-winx64\ bin. If you don't run as an administrator, you will be denied insufficient permissions

Run the following three commands in turn

mysqld --initialize-insecure

The data directory is automatically created under D:\ devtool\ mysql-5. 7.17-winx64\ instead of creating the data directory manually

mysqld -install

This step is to install the mysql service. If it is not run by the administrator, it will prompt "Install/Remove of the Service Denied!" If the bin directory service from cd to mysql is installed and the default path is C:\ Program Files\ MySQL\, the service will fail to start. "

System Error 2 occurred. The system cannot find the specified file "

net start mysql

This step is to start the mysql service. Without Step 1, this step will fail to start and prompt "Please type NET HELPMSG 3534 for more help."

After starting mysql, you can enter mysql-u root-p enter in cmd to complete the initial login

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.17

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

References:

Starting with MySQL 5.7. 6, install the solution to the MySQL prompt "Please type NET HELPMSG 3534 for more help."

MySQL 5.6 for Windows Extracted Edition Configuration Installation

Supplementary information:

After starting mysql, you can enter mysql-u root-p enter in cmd for the first time. According to the previous articles, the initial password is empty, but after direct enter, "ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)" appears after search MySQL ERROR 1045 (28000): The real reason for Access denied for user 'root' @ 'localhost' (using password: NO) This article is on Linux, but it is mentioned that a random password has been generated. Tell me directly what you may find in the automatically generated data directory. Open the file of "computer name. err" (computer name is different according to the actual situation, not the words itself). Search password and try that password successfully

You can select--initialize-insecure or--initialize to initialize,--initialize-insecure to initialize root password is empty, if--initialize is used to initialize, a random password will be generated

-Excerpt from mysql 5.7. 11 zip Installation-happymzw

The official documents are: https://dev.mysql.com/doc/refman/5. 7/en/windows-initialize-data-directory.html

https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html