Mysql-5.7-win64 Database Installation Tutorial Compression decompression version installed in Win10 installation configuration process schematic diagram simple fool-style one-stop tutorial (last update 2017.7.2)

Recently in Win8 and Win10 toss, install several times MySQL is unsuccessful. If you are having such a problem. Congratulations, here's the way . Summarize it now.

1. Download MySQL 5.7 window64-bit Community compressed version: https://dev.mysql.com/downloads/file/?id=469273

2. Configure the system environment variable under path: C:\Users\wyh\Documents\mysql-5.7.18-winx64\bin(the bin directory of your MySQL directory)

3. Test: Can come out to indicate the success of environment variable configuration

4. Open the cmd command line (must be administrator mode)

A. Tap:

　　　

Mysqld-install

　　　

　　　(This is when the MySQL service is installed, if the automatic installation path is incorrect, this step is replaced by the input: sc create mysql binpath= "C:\Users\wyh\Documents\mysql-5.7.18-winx64\bin\ Mysqld.exe "; That is, manually create the service, note that the Mysqld.exe is the network listener for MySQL.

B.

mysqld--initialize (This is the initialization of some basic tables, will be in the MySQL directory to establish the Data folder, there are Infomation_schema,mysql,sys and other system tables)

　　

C.

Create the My.ini configuration file in the MySQL root directory and write

[Mysqld]
Skip-grant-tables

　　　　Pass permission check, without password can log on

　　

D. Then enter the net start MySQL startup service in CMD, MySQL is the name of your service, initialize it to succeed:

E. Then login to the root account to change the password operation, no password

Here's the key:

Update mysql.user set password_expired= ' N ' where user= ' root '; (this sentence means that the password is not set, it must be, otherwise white change)

Update Mysql.user set Authentication_string=password (") where user= ' root '; (fixed wording, I set a blank password here, set on demand)

After the setup is done, quit the service net stop MySQL

5. In the previous My.ini file, add the pound sign to comment out the skip-grant-tables, or delete the file directly

OK, then restart Service net start MySQL use your new password to log in

Log on successfully, then operate as usual

If you follow the above method, respect for my labor results, message to inform, so that I happy happy. :)

　　

Mysql-5.7-win64 Database Installation Tutorial Compression decompression version installed in Win10 installation configuration process schematic diagram simple fool-style one-stop tutorial (last update 2017.7.2)