Mysql-5.7.winx64 Decompression Version Installation

New My.ini
Create a new TXT document, Save as My.ini, and put it in the MySQL directory

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=d:\program files\mysql-5.7.21-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\program Files\mysql-5.7.21-winx64\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb

Install data below
Add Bin directory to PATH environment variable

Environment variable configuration: My Computer--Properties--environment variables--join: D:\Program Files\mysql-5.7.23-winx64\bin

Generate the Data directory **************

CMD with admin access

Input format:

D:

CD D:\Program Files\mysql-5.7.23-winx64\bin

Enter in Bin directory

Mysqld--initialize-insecure--user=mysql//Generate Data directory (MySQL 5.7.16 default is not to provide the data directory)

Installation Services

Tip: The service was successfully installed.

Start the service

Mysqld--remove//Delete Service

Mysqld--install//Installation Services

net start MySQL//start service

net stop MySQL//Turn off the MySQL service command

Log in to MySQL

Mysql-hlocalhost-uroot-p

Password is root by default

Enter MySQL input

Show databases//view database

Exit//Quit

If you do not have a password, set the password as follows:

MySQL default root user is not set password, we can modify the root user password, the method is as follows:

1, directly in the cmd command line, do not need to enter MySQL

mysqladmin-u root password ' new password '

Mysql-5.7.winx64 Decompression Version Installation