MySQL 5.7 Installation Guide

1. Download
1) into the Hogne network download 5.7.23 compressed package
: Https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2. Installation and Configuration

1) Unzip the downloaded package to any directory, such as:

2) Create a My.ini configuration under the root directory? file

3)? Open My.ini with Notepad and fill in the following configuration information
[mysqld]
# set the server-side to use a character set of Utf-8
character-set-server=utf8
# bind IPv4 Address
bind-address = 0.0.0.0
# Set the end of MySQL port?"
port = 3306
Span style= "color: #3366ff; font-size:18pt "># setting up MySQL installation? directory
basedir=c:/mysql-5.7.23

# set data storage for MySQL database? directory
datadir=c:/mysql-5.7.23/data
# allow most large number of connections
max_connections=2000
# The default storage engine that will be used when creating a new table
DEFAULT-STORAGE-ENGINE=INNODB # Set the default encoding for MySQL and the database
[mysql ]
default-character-set=utf8 [Mysql.server]
Span style= "color: #3366ff; font-size:18pt ">default-character-set=utf8
# set the client default character set
[client]
default-character-set=utf8

(Note: You need to modify the Basedir and DataDir path in the upper-face configuration.)
4) Install MySQL service
Open the CMD window as a management manager, enter the bin in the MySQL directory, and then take the line Mysqld-install command, such as:

(Note: If you are prompted to find a DLL? file, please install the relevant VC shipping line library)
5) Initialize MySQL database
Create the data sub directory in the MySQL root directory first, such as:

Then proceed to the command line of the bin mysqld--initialize--user=root--console command line initialization, such as:

(Note: When the initialization is complete, will mysql be the root? user created? A default password, the subsequent need to use this password to log on to MySQL, the upper side of the white color section is the initial password)
6) Start the MySQL service

The line line net start MySQL command, such as:

7) Login to MySQL
Into the MySQL bin? catalogue, mysql-u "user-p password" login to MySQL, this? User is root, password is the default password for MySQL that was initialized just now, such as:

3. Change the root password
Root? The user's default initialization password is not that? Easy to remember, we can log in to MySQL last line modification, so that? with Set password = password (' password ') statement sentence in the line line more updated, such as:

This is the root of this? The user's password is also changed to root, and then lost? Enter \q to exit MySQL and make a login with a new password, such as:

4. Configure the amount of environment variables
MySQL bin? The directory holds the relevant command program, if you want to do these procedures in the command line line, each time must be entered into the bin directory, we can configure it to the system environment variable amount, such as:

Add the route path of the C:\mysql-5.7.23\bin directory to the PATH variable amount of the environment variable amount
5. Uninstall
As the management manager, the line of CMD, the line line net stop mysql command stop the MySQL service, and then the line mysqld-remove command uninstall the service, and finally delete the entire MySQL directory.

MySQL 5.7 Installation Guide