MySQL5.7.16 Green Edition installation tutorial details, mysql5.7.16 details

MySQL5.7.16 Green Edition installation tutorial details, mysql5.7.16 details

The following describes how to install MySQL5.7.16 Green Edition:

:

Original window command

Microsoft Windows [version 10.0.xxxxx] (c) 2016 Microsoft Corporation. All rights reserved. C: \ WINDOWS \ system32> mysqld -- initialize-insecure -- console2016-10-16T21: 45: 48.466872Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. please use -- explicit_defaults_for_timestamp server option (see documentation for more details ). 2016-10-16T21: 45: 49.862877Z 0 [Warning] InnoDB: New log files created, LSN = 457902016-10-16T21: 45: 50.240119Z 0 [Warning] InnoDB: Creating foreign key const Raint system tables.2016-10-16T21: 45: 50.457297Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. generating a new UUID: e7a7d27d-93e9-11e6-a549-f8a963e68bc7.2016-10-16T21: 45: 50.482293Z 0 [Warning] Gtid table is not ready to be used. table 'mysql. gtid_executed 'cannot be opened.2016-10-16T21: 45: 50.48420.z 1 [Warning] root @ local Host is created with an empty password! Please consider switching off the -- initialize-insecure option. c: \ WINDOWS \ system32> mysqld-installService successfully installed. c: \ WINDOWS \ system32> net start mysqlMySQL service is starting. the MySQL service has been started successfully. C: \ WINDOWS \ system32> mysql-u root -- skip-passwordmysql: [Warning] Using a password on the command line interface can be insecure. welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 2 Server version: 5.7.16 MySQL Community Server (GPL) Copyright (c) 2000,201 6, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql> alter user 'root' @ 'localhost' identified by 'root2016 '; Query OK, 0 rows affected (0.00 sec) mysql> \ quitByeC: \ WINDOWS \ system32> mysql-h localhost-uroot-pEnter password: ******** Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 3 Server version: 5.7.16 MySQL Community Server (GPL) Copyright (c) 2000,201 6, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql>

The above is a detailed explanation of the MySQL5.7.16 green installation tutorial. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!