mysql 5.7.11 winx64Installation and Configuration Tutorial with Pictures and Text

Install and configure the MySql database system.

　1Download

http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip

2.Unzip the zip package

D:\Program Files\mysql-5.7.11-winx64 

3.Configure the environment variable

3.1 Add the path path,

D:\Program Files\mysql-5.7.11-winx64\bin

3.2.Modify mysql-default.ini configuration file,

original

# These are commonly set, remove the # and set as required.
# basedir = ......
# datadir = ......
# port = ......
# server_id = ......

Change to

# These are commonly set, remove the # and set as required.
 basedir = D:\Program Files\mysql-5.7.11-winx64
 datadir = D:\Program Files\mysql-5.7.11-winx64\Data
 port = 3306
# server_id = ......

4.Enter the command prompt cmd as an administrator　

Enter the mysql bin directory,

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>cd D:
D:\
C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin
C:\Users\Administrator>d:
D:\Program Files\mysql-5.7.11-winx64\bin> 

Execute mysqld.exe --initialize command,

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize
D:\Program Files\mysql-5.7.11-winx64\bin>

The data directory was created

5.Execute mysqld -install command

D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install
Service successfully installed. //Service installed successfully

　6.Execute mysqld.exe -nt --skip-grant-tables

Note: The window is unresponsive

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>cd D:
D:\
C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin
C:\Users\Administrator>d:
D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize
D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install
Service successfully installed. //Service installation successful
D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe -nt --skip-grant-tables 

7.Reopen the dos window, execute mysql -u root

Enter the mysql command line, execute the command use mysql; update user set authtication_string=Password('123456); where user="root"; set password=Password('123456);

Press Ctrl+C Copy code

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>mysqld.exe -nt --skip-grant-tables
C:\Users\Administrator>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.11 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Database changed
123456')
 -123456')
 ->

Press Ctrl+C Copy code

8In the Task Manager, terminate the mysqld process, and start the mysql service.

Installation completed.

Wonderful topic sharing: mysql installation tutorials for different versions mysql5.7Installation tutorials for all versions mysql5.6Installation tutorials for all versions

That's all for the content of this article. Hope it helps everyone's learning and also hope everyone will support the Yelling Tutorial.

Statement: The content of this article is from the Internet, and the copyright belongs to the original author. The content is contributed and uploaded by Internet users spontaneously, and this website does not own the copyright, nor has it been manually edited, nor does it assume any relevant legal liability. If you find any content suspected of copyright infringement, please send an email to: notice#w3Please replace '#' with '@' when sending an email to report violations, and provide relevant evidence. Once verified, this site will immediately delete the content suspected of infringement.