MySql5.7. 21 Installation notes

Download is Zip decompressed version, Windows system, because it has not been installed on Windows for a long time, this installation found several places and the previous installation is not 1 kind of place, special record is as follows, for your reference

MySQL Profile Location

mysql_config. pl under bin directory

Installing the MySQL service

Enter the bin directory

mysqld --install
mysqld --remove

MySQL initialization

mysqld --explicit_defaults_for_timestamp --initialize

Random cipher

Generation location: 507B9DE08DE0. err in the data directory. Search for "temporary password" at the end of err, and get a random password. After logging in with this password, MySQL security policy will require modifying password modification command

alter user root@localhost identified by '123456';

Summarize