Windows install MySQL

Download the Unzip installation package

1. Initialize the database and execute the command in the bin directory of the MySQL installation directory: Execute command mysqld--initialize--console
A temporary password was generated: 9o8;1#0#ikek

2018-06-08t02:48:43.804512z 0 [System] [MY-013169] [Server] D:\Software\mysql\bi
N\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 25324

2018-06-08t02:49:00.346512z 5 [Note] [MY-010454] [Server] A temporary password i
s generated for [email protected]: 9o8;1#0#ikek
2018-06-08t02:49:09.428512z 0 [System] [MY-013170] [Server] D:\Software\mysql\bi
N\mysqld.exe (mysqld 8.0.11) initializing of server has completed

2. Execute the command under the bin directory of the MySQL installation directory, run CMD,MYSQLD--install [service name] in Administrator mode
Service successfully installed.

After the service name can not be written, the default name is MySQL. Of course, if you need to install more than one MySQL service on your computer, you can differentiate it with different names, such as Mysqlxxx and mysqlyyy.

3. Start Stop MySQL Service
net start MySQL
net stop MySQL

4. Login
Mysql-u root-p

5, Change Password

ALTER USER ' root ' @ ' localhost ' identified with mysql_native_password by ' root ';

6. Common commands

Windows install MySQL