Mysql-5.7.15-winx64 installation under the Windows 10 platform

Source: Internet
Author: User
Tags mysql client mysql version

White hair fishing firewood on the river, accustomed to see twists.

A pot of turbid wine to meet, ancient and modern how many things, all pay a joke. --" Riverside Fairy"

First, download

1. Download MySQL version on the official website: https://downloads.mysql.com/archives/community/

2. Download complete decompression to the specified path:

Second, configure MySQL

Under the mysql-5.7.15-winx64 directory, copy My-default.ini is named My.ini.

Configuring the My.ini File

[MySQL]# Set the MySQL client default character setdefault-character-Set=UTF8[mysqld]# Set 3306 ports Port= 3306Skip-Grant-tables# Set the installation directory for MySQL Basedir=D:\Program Files (x86) \mysql-5.7. the-winx64# Set the data storage directory for the MySQL database DataDir=D:\Program Files (x86) \mysql-5.7. the-winx64\data# Maximum number of connections allowed Max_connections= $# The character set used by the service side defaults to the 8-bit encoded latin1 character Setcharacter-Set-Server=utf8# default storage engine to use when creating a new tabledefault-Storage-Engine=INNODB

Third, install the MySQL service

1. Run cmd as Administrator and specify to the MySQL installation location under Bin file, run mysqld install installation

2. Use mysqld--initialize to initialize the data directory, and in the installation directory

Iv. Change of password

  1. Start the MySQL service;

2. Go to MySQL database and change password

Mysql>  UseMySQL;DatabaseChangedmysql> UpdateMysql.User SetAuthentication_string=Password'zxm5312')where User='Root'; Query OK,1Row affected,1Warning (0.00sec) Rows matched:1Changed:1Warnings:1MySQL>FlushPrivileges; Query OK,0Rows Affected (0.00Sec

Mysql> set Password=password (' zxm5312 ');
Query OK, 0 rows affected, 1 Warning (0.00 sec)

3. Exit the MySQL service, comment out the config file in Skip-grant-tables, and then restart the MySQL service to log in to the MySQL database.

[MySQL]# Set the MySQL client default character setdefault-character-Set=UTF8[mysqld]# Set 3306 ports Port= 3306# Skip-Grant-Tables[comment out here]# Set up the MySQL installation directory Basedir=D:\Program Files (x86) \mysql-5.7. the-winx64# Set the data storage directory for the MySQL database DataDir=D:\Program Files (x86) \mysql-5.7. the-winx64\data# Maximum number of connections allowed Max_connections= $# The character set used by the service side defaults to the 8-bit encoded latin1 character Setcharacter-Set-Server=Utf8

Mysql-5.7.15-winx64 installation under the Windows 10 platform

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.