Mysql5.7.19-win64 Installation Start

1. MySQL Community Server Community version, open source is free, but does not provide official technical support. Select the install-free version below: Windows (x86, 64-bit). zip

2. Unzip, put it under C: \ and store the path to C:\MySQL5.7\

3. Initialize, install the service, start the service.

Start cmd as an administrator and go to the MySQL bin directory.

Mysqld–initialize--inscure (This step will generate a login password, to be noted)

Mysqld--install

net start MySQL

4. Start unsuccessful processing

For the 5.7.19 version, if the net start MySQL command starts the service at this time, it will be initialized automatically, it may be configured successfully, but in most cases the service will not start, it's okay to initialize the initialization command. Before beginning the C:\MySQL5.7\Data, empty the files in the file and execute the initial command:

Mysqld--initialize--user=mysq L--console

After execution, the CMD console displays a large pile of English, and the last line is the password, which needs to be written down.

5. Log in to the MySQL database

C:>mysql–u root–p

You need to enter the password you wrote down when initializing, so log in to the database, such as:

6. Change the database login password

Mysql>use MySQL;

mysql> SET Password=password ("123456");

Mysql>quit

Mysql5.7.19-win64 Installation Start