MySQL free install 5.7.17 Database Configuration

First, there must be mysql-5.7.10-winx64.

Environment: Mysql-5.7.10-winx64 + WIN10 (64-bit)

To configure environment variables:

1, put mysql-5.7.10-winx64 to D disk, enter D\mysql-5.7.10-winx64\bin directory, copy path, configure environment variables, add d\mysql-5.7.10-winx64\bin after path, complete.

2. Edit the MySQL configuration file

The red is the path to the MySQL file.

3, cmd as administrator to enter the bin directory, in the bin directory input mysqld--install, install MySQL

4. Initialize MySQL and continue typing in bin directory: mysqld--initialize--console

5, this is the initialization database, then you can see in the final initialization of an [email protected]: There is a series of alphanumeric symbols, this is the MySQL automatically generated for you random password. To write it down, we'll use it when we log in to the MySQL database.

6. Start MySQL, enter under bin: net start MySQL or click MySQL boot in Windows service

7, modify the MySQL password, start MySQL, input mysql-u root-p, at this time you want to write down the password entered, login after input: SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' new password ');

8. Configure SQLyog Graphical interface

MySQL free install 5.7.17 Database Configuration