Mysql5.7.13.zip installation (Windows)

Source: Internet
Author: User
Tags mysql free system log uuid

There was a problem when I installed the 5.6 installation method (MySQL free installation download and configuration) before installing 5.7:

The MySQL service failed to start and the service did not report any errors

In fact, in the beginning of this semester to learn MySQL, listen to the teacher classmate said, the problem of login, did not care, but also because the computer has been installed mysql5.6, also did not care about this problem. These two days WIN10 system problem, reinstall the Win7, install 5.7 when the problem arises.

The previous version of the default password is empty, the specific version is not very clear, anyway 5.6 password is empty. 5.7 Security promotion, in the Linux installation 5.7, the installation will generate a random password, stored in the Root/.mysql_secret, if there is no such file, go to the System log to find password, you should be able to find.

But Windows does not know how to solve, but finally found a solution.

Workaround:

From: Windows MYSQL 5.7.9, no boot. Missing data

However, the Data folder is not missing, rename the My-default.ini file to My.ini, move to the bin/directory, execute the command under bin/mysqld--initialize--user=mysql , this command is expected to be an initialized command

Then start the service net start MySQL

Command line display posted on this

Microsoft Windows [version6.1.7601] Copyright (c) theMicrosoft Corporation. All rights reserved. C:\Windows\system32>CD.. C:\Windows>CD.. C +>CD mysql-5.7. --winx64/the boot system could not find the path specified. C +>CD mysql-5.7. --Winx64\binc:\mysql-5.7. --winx64\bin>mysqldInstallService successfully installed. C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service could not be started. The service did not report any errors. Please type NET helpmsg3534to get more help. C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service could not be started. The service did not report any errors. Please type NET helpmsg3534to get more help. C:\mysql-5.7. --winx64\bin>mysqld--initialize--user=mysql--Console .- .-21T14: -: -.922112Z0[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. please use--explicit_defaults_for_timestamp server Option (see documentation for  Moredetails). .- .-21T14: -: A.669315Z0[Warning] Innodb:new log files created, lsn=45790 .- .-21T14: -: at.106116Z0[Warning] innodb:creating foreign key constraintsystem tables. .- .-21T14: -: at.308916Z0[Warning] No existing UUID have been found, so we assume the TimeThat this server has been started. Generatinga New uuid:79c8386d-37b9-11e6-9709-74867a6179b7. .- .-21T14: -: at.340116Z0[Warning] Gtid table is not a ready-to-be used. Table'mysql.gtid_executed'cannot be opened. .- .-21T14: -: at.355716Z1[Note] A temporary password is generated for[Email Protected]localhost:rr9.8h74twfrc:\mysql-5.7. --winx64\bin>mysql-uroot-prr9.8h74twfrmysql: [Warning] Using a password on the command line interface can be insecure. ERROR2003(HY000): Can't connect to MySQL server on'localhost'(10061)C:\mysql-5.7. --winx64\bin>net start Mysqlmysql service is starting. The MySQL service has started successfully. C:\mysql-5.7. --winx64\bin>mysql-uroot-prr9.8h74twfrmysql: [Warning] Using a password on the command line interface can be insecure.  Welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs2Server Version:5.7. -Copyright (c) -, ., Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'ToClearThe current input statement.mysql> Set Password=password ("'); Query OK,0Rows affected,1Warning (0.00sec) MySQL>Exitbyec:\mysql-5.7. --winx64\bin>mysql-Urootwelcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs3Server Version:5.7. -MySQL Community Server (GPL) Copyright (c) -, ., Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'ToClearThe current input statement.mysql>Exitbyec:\mysql-5.7. --winx64\bin>
View Code

Mysql5.7.13.zip installation (Windows)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.