MySQL decompression version installation under Windows (WIN10)

1. To the MySQL official website download mysql:http://dev.mysql.com/downloads/mysql/, will prompt the login, registers one on the line, the company name and so on casually fills.

Note the distinction between 32 and 64 bits. I'm using a 64-bit, version number (mysql-5.7.13-winx64.zip)

2. After extracting, add the Bin directory under the MySQL folder to the environment variable (system variable). (How to add please own Baidu)

3. After the completion of the MySQL directory is no data folder, Baidu above some tutorials say that they create a data, this is wrong! Don't create it yourself, don't create it yourself, don't create it yourself.

4. Find the My-default.ini file in the MySQL directory, copy the renamed to My.ini, the configuration does not need to be modified, of course, according to their own needs to modify the line, I added on [MySQL]

[Client]

Default-character-set=utf8

5. Add Service: Open cmd command mode (preferably open with administrator, Cmd.exe path: c:windows/system32/cmd.exe), switch to directory "F: own MySQL directory \ Bin", execute Mysqld-install MYSQL57 (available, default is MySQL, I use mysql57 this service name).

6. Initialize: Execute in cmd: MySQL--initialize

Please be patient for about 1 minutes, and re-cursor at the bin path indicates initialization is complete.

After execution, the data folder is generated in the MySQL directory.

7. Start Mysql:net start mysql57 (the name I used when I added the service was mysql57)

8. View the default randomly generated root default password:

Open file->f: Your own MySQL directory/data/pc201508020502.err (filename and your computer name related, find the. err suffix of the file just)

　　

　　

　　

Search for password in this file, match to a temporary password is generated for [email protected]: xxxxxxxxxx,

XXXXXXXXXX is the initial password.

　　

　　

9. Login: Execute mysql-u root-p in cmd

And then the password to fill in the corresponding xxxxxxxxxx

　

OK, the installation is complete.

10. When executing show databases, the error will be prompted: You must reset your password using ALTER USER statement before executing this statement.

We need to reset the password: set password = password (' Fill in the password you want to set here ');

　　

　　

Then you can connect to MySQL directly with Navicat.

MySQL decompression version installation under Windows (WIN10)