64-bit win10 system installation Green Edition mysql-5.7.16-winx64 tutorial, mysql Green Edition download 64-bit

Source: Internet
Author: User

64-bit win10 system installation Green Edition mysql-5.7.16-winx64 tutorial, mysql Green Edition download 64-bit

This article mainly introduces the 64-bit win10 system installation of Green Edition mysql-5.7.16-winx64 method, the specific content is as follows:

1. DownloadMySQL Community Server

Address: http://dev.mysql.com/downloads/mysql/

Select Windows (x86, 64-bit) and ZIP Archive for download.

2. decompress the MySQL installation package to the specified directory., My directory is D: \ Program Files \ MySql \ mysql-5.7.16-winx64, and copy a my-default.ini file for backup.

3. Modify the my-default.ini File

Basedir = D: \ Program Files \ MySql \ mysql-5.7.16-winx64

Datadir = D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ data

Port = 3306

Note: remove the source file #

4. Add Environment Variables

New system variable MYSQL_HOME, variable value: D: \ Program Files \ MySql \ mysql-5.7.16-winx64

Modify the system variable Path and add % MYSQL_HOME % \ bin;

Note: variable values should be separated by commas (,).

5. Register windows Services

Open cmd with administrator permissions, enter the D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ bin directory,

Enter the service installation command: mysqld install MySQL -- defaults-file = "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ my-default.ini"

View the ImagePath value in the registry, my is "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ bin \ mysqld" -- defaults-file = "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ my-default.ini "MySQL, which contains mysqld, will not be modified.

Registry location: \ HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MySQL
Execute mysqld -- initialize for initialization (generate data directory)

Execute net start MySQL

6. Modify the Default root Password

Find the initial password for MySQL, open the file D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ data under the directory suffix err, my DESKTOP-KCIHHJT.err

Search for the password keyword. My information is: A temporary password is generated for root @ localhost: = 2 v & I * 7Nab0r
The generated initial password is = 2 v & I * 7Nab0r

Run mysql-uroot-p

Enter the above initial password to access MySQL.

Execute set password = PASSWORD ('20140901 ');

Change Password to 123456

Use exit to exit MySQL, and then you can log on with the new password.

The above is a small series to introduce you to the 64-bit win10 system installation Green Edition mysql-5.7.16-winx64 tutorial, hope to help everyone, if you have any questions please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!

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.