MySQL free installation (win7 64-bit system)

Source: Internet
Author: User
Tags mysql free

First, decompression
second, run cmd as Administrator
three, cmd command into the extracted MySQL file under the bin directory
iv. Add the MySQL service to the Windows service. CMD input in Bin directory: Mysqld-install (remove service command mysqld Remove)
v. Start MySQL. Command: net start MySQL (stop: net stop MySQL. No direct restart command under Windows, only stop and restart
Six, set the user name and password. The default user name is root and the password is empty.
Seven, can modify the My.ini configuration file of the MySQL parameters (My.ini file in the extracted directory)
Some of the problems encountered
1. You must run CMD as an administrator, or you may fail to add the MYSQLD service.
2. The used database needs to be redeployed and the log file will be emptied.

Error log: (View log: Computer Right--admin--Event Viewer--windows Log--application)

2016-5-31 17:20:14 error InnoDB:./ibdata1 can ' t be opened in Read-write mode

2016-5-31 17:20:14 Error innodb:the system tablespace must be writable!

2016-5-31 17:20:14 error Plugin ' InnoDB ' init function returned error.

2016-5-31 17:20:14 error Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.

2016-5-31 17:20:14 error unknown/unsupported storage Engine:innodb

2016-5-31 17:20:14 error aborting

2016-5-31 17:20:14 Info Binlog End

Workaround:

1. Open the Task Manager to terminate the MYSQLD process;

2. Open the Data folder of the MySQL installation directory and delete the following 2 files:ib_logfile0 and ib_logfile1

3. Restart MySQL

MySQL free installation (win7 64-bit system)

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.