Mysql 5.7.17 winx64.zipan Assembly placement tutorial, 5.7.17winx64.zip

Mysql 5.7.17 winx64.zipan Assembly placement tutorial, 5.7.17winx64.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.

Reference link: graphic tutorial on how to install and configure mysql 5.7.11 winx64.zip;
Some of the steps are always wrong after I finish them. I will try 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 original mysql-default.ini configuration file:

# 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

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

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