MySQL 5.7 Compression pack installation Notes

Reprint please specify the source http://www.cnblogs.com/havedream/p/5075263.html

Reinstall the system after the installation of MySQL, see the official web has MySQL 5.7.10 can download on the point, and then began a long installation distance, total toss almost one hours, finally installed successfully, here to write down the installation process, to make a note to yourself, but also to yimeimei a installation hint.

1. Download the installation package

Directly click or copy after you can download, not too troublesome or want to experience other versions of the official website can also be downloaded, but note that the notes only in 5.7.10 this version of the successful operation, other versions (for reference only) need to refer to the official installation documentation!

http://120.192.95.132/cache/dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10-winx64.zip?ich_args= 33a24030fa5191a36f50adaf2a0329c5_1_0_0_5_9c71accd314cb3f9f9f6e66f07ef13e42dd4f7c2bf4ea27f34b88c04e33f0945_ 80de45f03e1c6ffbe40617244bdec41b_1_0&ich_ip=

2. Unzip the folder to a local disk

I put the papers on the

C:\Program_Files\mysql-5.7. Ten-winx64

3. Copy My-default.ini to My.ini

Suggest a copy, or rename the My-default.ini directly to My.ini

4. Fill in My.ini related content

basedir=c:\program_files\mysql-5.7. Ten-winx64
datadir=c:\program_files\mysql-5.7.  Ten-winx64\data
Port=3306

Please replace the path with your actual path!

5. Environment variables

New environment variables, such as

Modify the path, note that it is modified, add the part that I selected later

%mysql_home%\bin;

6. Administrator privileges Run [command prompt]

Try to run with administrator privileges, or you may be unable to install or fail to start the service, and so on!

7. Execute MySQL initialization data

Mysqld--initialize--console

The results are as follows:

C:\windows\system32>mysqld--initialize--Console -- A-25t03: on: -.140732Z0[Warning] TIMESTAMP withImplicitDEFAULT value isDeprecated. --explicit_defaults_for_timestamp server option (see documentation forMore details).  -- A-25t03: on: -.140732Z0[Warning]'no_zero_date','no_zero_in_date'and'Error_for_division_by_zero'SQL modes should is used with strict mode. They'll be merged with strict modeincha future release. -- A-25t03: on: -.140732Z0[Warning]'No_auto_create_user'SQL mode is notSet.
 -- A-25t03: on: the.614085Z0[Warning] Innodb:new log files created, lsn=45790
 -- A-25t03: on: the.775606Z0[Warning] innodb:creating FOREIGN KEY constraint system tables. -- A-25t03: on: the.872089Z0[Warning] No existing UUID has been found, so we assume that This  isThe first time that ThisServer has been started. Generating aNewuuid:ceb98c90-aab3-11e5-8ca7-b870f4733564. -- A-25t03: on: the.872089Z0[Warning] Gtid table isNot ready to be used. Table'mysql.gtid_executed'cannot be opened. -- A-25t03: on: the.891376Z1[Note] A Temporary password isGenerated for[Email protected]: +>><=GS,0SPF

Please note that the last sentence contains the initialization password we need!!!!

8. Install the MySQL service and start

C:\windows\system32>mysqld-Install
Service successfully installed.

C:\Windows\system32>net start mysql MySQL
service is starting.
The MySQL service has started successfully. 

9. Log in to MySQL and change the password

Please note that my password below is not the same as the initialization password above, because I have re-uninstalled the service and then re-executed again 7 and 8, because the above password prompt I cannot log on, "<" is not recognized!!! Don't know if anyone knows why? is random passwords too random?

c:\windows\system32>mysql-uroot-pih.sqwazk9*7

Mysql>  setfor'root'@'localhost' =" your password ";
 0 rows affected (0.00 sec)

Okay, now quit.

Mysql> exit
Bye

10. Modify Remote Login

By the time of 9, the machine has been able to use the MySQL function normally, but if you need to telnet to MySQL, the following settings are required

C:\windows\system32>mysql-uroot-p your password mysql: [Warning] Using a password on the command lineInterfacecan be insecure.  Welcome to the MySQL Monitor. Commands End With;
or \g. Your MySQL Connection ID is 3Server Version:5.7.TenMySQL Community Server (GPL) Copyright (c) -, -, Oracle and/or its affiliates.

All rights reserved. Oracle isA registered trademark of Oracle Corporation and/or its affiliates.

Other names trademarks of their respective owners. Type'Help ;'Or'\h'  forHelp. Type'\c'To clear the current input statement. MySQL>Use mysql Database changed MySQL>SelectHost,user fromuser;+-----------+-----------+
| Host |
user | +-----------+-----------+
| localhost | Mysql.sys | | localhost |
Root | +-----------+-----------+2Rowsinch Set(0.00sec)MySQL> Update UserSethost='%' whereuser ='Root'; Query OK,1Row affected (0.00sec) Rows matched:1Changed:1Warnings:0MySQL>SelectHost,user fromuser;+-----------+-----------+
| Host |
user | +-----------+-----------+
| %         | Root | | localhost |
Mysql.sys | +-----------+-----------+2Rowsinch Set(0.00sec) MySQL>

All right, all done here, start your MySQL trip!

Reprint please specify the source http://www.cnblogs.com/havedream/p/5075263.html

MySQL 5.7 Compression pack installation Notes