Detailed steps for installing and configuring MySQL 5.7 zip (zip)

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!