Win10 mysql 5.7.17 zip package version installation tutorial, win105.7.17

Win10 mysql 5.7.17 zip package version installation tutorial, win105.7.17

The installation tutorial of mysql5.7.17 is for your reference. The specific content is as follows:

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

Extract

D: \ devtool \ mysql-5.7.17-winx64 \

Add D: \ devtool \ mysql-5.7.17-winx64 \ bin to Environment Variables

Right-click the windows icon in the taskbar-> command prompt (Administrator) and run cmd, cd to D: \ devtool \ mysql-5.7.17-winx64 \ bin as administrator. If it is not run as an administrator, insufficient permissions will be denied.

Run the following three commands in sequence:

Mysqld -- initialize-insecure

The data directory is automatically created under D: \ devtool \ mysql-5.7.17-winx64 \ without the need to manually create the data directory

Mysqld-install

This step is to Install the mysql Service. If it is not run by the Administrator, the system prompts "Install/Remove of the Service Denied !" If the path to the mysql bin directory service is C: \ Program Files \ MySQL \ by default after installation without cd, the error message"

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

Net start mysql

This step is to start the mysql service. If there is no first step, this step will fail to start and prompt "please type net helpmsg 3534 for more help"

After mysql is started, 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 7Server version: 5.7.17Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> 

References:

From MySQL5.7.6, the installation of MySQL prompts "Enter net helpmsg 3534 for more help" SOLUTION

MySQL 5.6 for Windows decompressed version configuration Installation

Additional information:

After mysql is started, you can enter mysql-u root-p enter in cmd to log on for the first time, according to some previous articles, the initial password is empty, but after entering directly, "ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO) appears) "MySQL ERROR 1045 (28000) after searching: Access denied for user 'root' @ 'localhost' (using password: NO) the real reason for this is: Xiaoxiang -blog is written on Linux, but when it comes to generating a random password, it directly tells me what may be found in the automatically generated data directory, open "computer name. "err" file (the computer name varies according to the actual situation, not the words themselves) Search for the password and found that the password was successfully tried.

You can choose to use -- initialize-insecure or -- initialize for initialization, and -- initialize-insecure for initialization. the root password is blank. If you use -- initialize for initialization, a random password will be generated.

-- From mysql 5.7.11 zip installation-happymzw

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

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