Install mysql windows 5.7.23

Install mysql windows in archive version

https://www.mysql.com download package first.

unpackage archive first, add ini file to the dirctory root.

1
2
3

mysqld –initialize-insecure –user=mysql
mysqld install
net start mysql

If success then use mysql -u root -p no password login.
If failed then delete data file , mysqld --initialize reinit mysql.

If login still failed like this:

1	ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

stop mysql net stop mysql
use mysqld --skip-grant-tables or
add skip-grant-tables to my.ini and start to skip mysql privilege check
then :

1 2	update user set authentication_string=password("root") where user="root"; flush privileges;

delete skip configuration, and restart mysql