解压Mysql并且配置修改初始密码

原文地址

PS E:\mysql-8.0.18-winx64> cd bin
PS E:\mysql-8.0.18-winx64\bin> mysqld --initialize --user=mysql --console
2019-11-07T12:36:16.278623Z 0 [System] [MY-013169] [Server] E:\mysql-8.0.18-winx64\bin\mysqld.exe (mysqld 8.0.18) initializing of server in progress as process 11552
2019-11-07T12:36:32.279594Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 0mds#D*yzBed
PS E:\mysql-8.0.18-winx64\bin>

PS E:\mysql-8.0.18-winx64> mysqld --install Mysql
The service already exists!
The current server installed: E:\mysql-8.0.18-winx64\bin\mysqld.exe MySQL
PS E:\mysql-8.0.18-winx64> net start MySQL

PS E:\mysql-8.0.18-winx64> mysql -u root -p
Enter password: ************

mysql> set password for root@localhost=“mysql”;
Query OK, 0 rows affected (0.10 sec)

mysql>