MySQL 5.7.16 decompression installation process

windows server 2012 64bit
mysql-5.7.16-winx64.zip

1. Unzip to d:/mysql/mysql5716, newly build d:/mysql/mysql5716/tmp, d:/mysql/mysql5716/log and d:/mysql/mysql5716/data Catalog , rename d:/mysql/mysql5716/my-default.ini by my.ini, And make appropriate modifications

[quote]

[mysql]
default-character-set=utf8

[mysqld]

# If you don't use double quotes , Backslash must be two ( Escape character )
basedir=D:/mysql/mysql5716
tmpdir=D:/mysql/mysql5716/tmp
datadir=D:/mysql/mysql5716/data
port=3306
server_id=1

character-set-server=utf8
default-storage-engine=INNODB
innodb_file_per_table=1
lower_case_table_names=1
innodb_buffer_pool_size = 128M
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M

# General and Slow logging.
log-output=FILE
slow-query-log=1
slow_query_log_file=D:/mysql/mysql5716/log/slow-query.log
long_query_time=5

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES


[/quote]

2. To configure winodws Environment variables of

3. Run the command line window with the Administrator , Get into d:/mysql/mysql5716/bin

4. stay mysql/bin Next , function ：
mysqld --install
Relative , The command to uninstall the service is ：mysql --remove MySQL（ Of course , You have to stop the service first ）

5. stay mysql/bin Next , function ：
mysqld --initialize --console
If it works , Then record the last prompt's default root@localhost password ;
If there is an error prompt , May be my.ini The directory configured in was not found （ such as tmpdir, You need to create it manually in advance ）

6. stay mysql/bin Next , function ：
net start MySQL
Successful launch .

7. stay mysql/bin Next , function ：
mysql -uroot -p
Enter and connect mysql, And enter the default password recorded above

8. stay mysql> The input ：
use msyql; Report the following error message , This is because of the first entry into mysql, Need modification root password
[quote]
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
[/quote]
9. stay mysql> The input ：
update mysql.user set authentication_string=password('12345678') where user='root' and Host = 'localhost';
modify root The password for 12345678. Be careful ： from 5.7 Start ,user Table no apssword This field , It is authentication_string Field .
[quote]
Query OK, 0 rows affected, 1 warning (0.00 sec)
[/quote]

Secondary installation 5.7.17, Running this won't work , Or to reset the password first , Then execute this sentence first ：
set password for 'root'@'localhost'=password('12345678');

10. stay mysql> The input ：
update mysql.user set host = '%' where user = 'root'; such ,mysql You can connect remotely with client tools .
11. Last , stay mysql> The input ：
flush privileges;
12. stay mysql/bin Next , function ：
net stop MySQL
stop it mysql, Run again ：
net start MySQL
To complete the restart .


At the beginning , No implementation of article 5 Step , Has been unable to start mysql service , Later, I looked up the information , Find out mysql5.7.7 After the version , The decompressed version no longer comes with data Initialize data , It is necessary to carry out section 5 Step to initialize mysql