Installation tutorial of MySQL 5.7.17 zip package version under win10

The installation tutorial of mysql5.7.17 is shared with you for your reference. The specific contents are as follows

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

Unzip

D:\devtool\mysql-5.7.17-winx64\

Add D:\devtool\mysql-5.7.17-winx64\bin to the environment variable

Right-click the Windows icon on the taskbar -> Command Prompt (Administrator), run cmd as an administrator, and cd to D:\devtool\mysql-5.7.17-winx64\bin. If you do not run it as an administrator, insufficient permissions will be denied.

Run the following three commands in sequence

mysqld --initialize-insecure

The data directory will be automatically created under D:\devtool\mysql-5.7.17-winx64\, so you don’t have to create the data directory manually.

mysqld -install

This step is to install the MySQL service. If you are not an administrator, you will be prompted with "Install/Remove of the Service Denied!" If you do not cd to the MySQL bin directory, the default path after the service is installed is C:\Program Files\MySQL\, and starting the service will fail with a prompt of "

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

net start mysql

This step is to start the mysql service. If the first step is not completed, this step will fail 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 first 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 from MySQL 5.7.6, the solution to the prompt "Please type NET HELPMSG 3534 for more help" when installing MySQL

MySQL 5.6 for Windows decompressed version configuration and installation

Additional information:

After starting MySQL, you can enter mysql -u root -p enter in cmd for the first login. According to some previous articles, the initial password is empty, but after directly pressing enter, "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" appears. After searching, the real reason for MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) - Xiaoxiang Hermit - Blog Garden This article is on Linux, but it mentions that a random password was generated. It directly tells me what I might find in the automatically generated data directory, open the "computer name.err" file (the computer name varies according to the actual situation, not these words itself) and search for password. Sure enough, I found it, and tried that password successfully.

You can choose to initialize with --initialize-insecure or --initialize. --initialize-insecure initializes the root password to empty. If you use --initialize to initialize, a random password will be generated.

——Excerpt from mysql 5.7.11 zip installation - happymzw

The official documentation says: 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 the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.