Mysql5.7-winx64 Zip Package installation process

1. First extract the download complete zip package to a directory, such as: E:\mysql-5.7.16-winx64
   

2. Modify environment variable Path increase E:\mysql-5.7.16-winx64\bin

3. Create a new directory data in the E:\mysql-5.7.16-winx64 directory, copy the default My-default.ini to My.ini, and configure the above fields:

   
   

   
   

Basedir = E:\mysql-5.7.16-winx64datadir = E:\mysql-5.7.16-winx64\dataport = 3306server_id = 1

Comment The last line

#sql_mode =no_engine_substitution,strict_trans_tables

Installing the MySQL Service

E:\mysql-5.7.16-winx64\bin>mysqld--install MySQL

Initialize MySQL, run cmd as Administrator, and go to the bin directory of MySQL to run

Mysqld--initialize--user=mysql --explicit_defaults_for_timestamp--console

Mysql-5.7.16-winx64\bin>mysqld --initialize --user=mysql  --explicit_defaults_for_ timestamp --console2016-10-15t04:38:46.341663z 0 [warning] innodb: new log  Files created, lsn=457902016-10-15t04:38:46.908164z 0 [warning] innodb: creating  foreign key constraint system tables.2016-10-15t04:38:47.111607z 0 [ Warning] no existing uuid has been found, so we assume that  this is the first time that this server has been  started. generating a new uuid: 42dda920-9291-11e6-a48e-00ff6bd10585.2016-10-15t04 :38:47.161759z 0 [warning] gtid table is not ready to be  used. table  ' mysql.gtid_executed '  cannot be opened.2016-10-15t04:38:47.182800z 1  [note] a temporarY password is generated for [email protected]: k9otza#ftmss 

Watch the last line of the password output

A temporary password is generated for [email protected]: K9OTZA#FTMSS

Start the service

E:\mysql-5.7.16-winx64\bin>net Start Mysqlmysql service is starting. The MySQL service has started successfully.

Log in with the above password

E:\mysql-5.7.16-winx64\bin>mysql-uroot-penter Password: ************welcome to the MySQL monitor. Commands End With; or \g.your MySQL connection ID is 2Server version:5.7.16copyright (c), and Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> exit

To modify the administrator password:

E:\mysql-5.7.16-winx64\bin>mysqladmin-uroot-p passwordenter Password: ************new password: ******Confirm New Password: ******

Login Verification with new password

e:\mysql-5.7.16-winx64\bin>mysql -uroot -p123456mysql:  [Warning] Using a password on the command line interface  Can be insecure. Welcome to the mysql monitor.  commands end with ; or \ g.your mysql connection id is 6server version: 5.7.16 mysql  community server  (GPL) copyright  (c)  2000, 2016, oracle and/or its  affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or  Itsaffiliates. other names may be trademarks of their respectiveowners . type  ' help; '  or  ' \h '  for help. Type  ' \c '  to clear the current input  statement.mysql> 

Turn off MySQL service

E:\mysql-5.7.16-winx64\bin>mysqladmin-uroot-p shutdownenter Password: ******

Start the MySQL service

E:\mysql-5.7.16-winx64\bin>net Start Mysqlmysql service is starting. The MySQL service has started successfully.

This article is from the "Sunny" blog, make sure to keep this source http://francis198.blog.51cto.com/720670/1862151

Mysql5.7-winx64 Zip Package installation process