Detailed steps for installing and configuring MySQL 5.7 zip (zip)
I had to reload win10 and sort out the files. However, it was not worthwhile to install MySQL for one afternoon. So I wrote this article to help you.
1. Download
Https://dev.mysql.com/downloads/mysql/
Ii. decompress the zip package
3. Configure Environment Variables
(1) Configure Path
(2) modify the mysql-default.ini configuration file
Original:
# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....
Modified:
4. Enter the command prompt cmd as an administrator
Note: First mysqld-install and then mysqld-initialize
(1) execute mysqld-install
C: \ Users \ donald> cd D: \ tools \ developer \ MySQL \ mysql-5.7.17-winx64 \ binC: \ Users \ donald> d: D: \ tools \ developer \ MySQL \ mysql-5.7.17-winx64 \ bin> mysqld-installService successfully installed. // The service is successfully installed.
(2) execute mysqld-initialize
D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld --initializeD:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>
The data folder is automatically created.
(3366mysqld.exe-nt-skip-grant-tables (Note: The Window does not respond)
D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld.exe -nt --skip-grant-tables
(4) Close the window directly and re-open dos (opened in the same administrator identity)
C: \ Users \ donald> mysql-u root Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 3 Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000,201 6, 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> use mysql Database changed mysql> update user set authtication_string = Password ('admin') where user = "root"; // At this time, a message indicating successful modification or waring is displayed. Mysql> flush privileges; 0 rows affected( 0.01 sec)
5. Check successful
(1) Terminate the mysqld process in the task manager and enable the mysql service.
C:\Users\donald>net start mysql
If:
Open the task manager, find mysqld, and end the process.
Then restart mysql.
(2) Input mysql-u root-p
C: \ Users \ donald> mysql-u root-p // enter admin
The preceding section describes how to install and configure MySQL 5.7 zip (zip). I hope it will be helpful to you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!